 |
|
|
thank you so much. Excellent Job
|
|
|
|
|
|
|
Hi,
After spending hours trying with CREATE and INSERT sql scripts to no avail, your program did it in seconds.
Thank you.
John
|
|
|
|
|
|
|
Thanks 
Liron
|
|
|
|
|
|
|
Hi Liron,
Many thanks for your converter. It's a fantastic tool.
I have a problem which is the resulting database created does not work on Windows Phone 7 (WP7).
The SQLite database format is supposed to be compatible on all platforms (Win, Linux, Android, iOS etc...) but does not seem to work on WP7.
Not sure if there is a problem with the SQLite client used in the converter or even the WP7 clients I used but the main message that occurs is relating to the schema being corrupt.
To get a populated database I create the database using a script on WP7 and then run the remaining code (CopySqlServerRowsToSQLiteDB onwards) and i have a database that can be used on WP7.
Anyway, just thought you should know even if it isn't anything to do with your code.
Thanks
|
|
|
|
|
|
|
Firstly,
thanks a lot for this tool - saved me heap of time.
I noticed however that my Sqlite database is larger than the SQL Compact equivalent (I exported SQL Server table to Sqlite and SQL Compact to compare sizes).
Any idea why this is so? All strings are declared as Varchar(size), and I made sure that numeric fields are using smallest data type able to hold data possible.
Regards,
Igor
|
|
|
|
|
|
|
I have no idea why the sizes are different.
But SQL compact and SQLite are totally different beasts. Sometimes the file sizes do not reflect actual data but rather different strategies of data storage (like linked structures etc) so the file size is not always a good indicator to the amount of actual data stored in a database file.
Liron
|
|
|
|
|
|
|
Hi,
I just found this nice tool and tested it against a database. Unfortunately it fails on converting tables containig fields with a space or other "special" character like "ä" (german) in it like "Sales Price".
It fails with the error message:
---------------------------
Conversion Failed
---------------------------
SQLite error
table Item has no column named Sales
---------------------------
OK
---------------------------
When I look in the generated sqlite db file, the table was already generated (with the same field names as in th sql db). So the conversion only fails on transfering the table data.
Am I the first using it against a database with such fieldnames or do I something wrong?
Best Regards,
Thomas
|
|
|
|
|
|
|
Ok, the problem were indices containing columns containing fieldnames with characters other than a-zA-Z_0-9 like [Customer No.] or with (german) foreign characters like [Verkäufer].
I changed the regex expression
from
private static Regex _keyRx = new Regex(@"([a-zA-Z_0-9]+)(\(\-\))?");
to
private static Regex _keyRx = new Regex(@"([a-zA-Z_äöüÄÖÜß0-9 .-]+)(\(\-\))?");
and because the fields in our databases also includes spaces I also had to change
Match m = _keyRx.Match(p);
to
Match m = _keyRx.Match(p.Trim());
Now we were able to convert our databases to sqlite. Great work, again thank you very much for this tool
|
|
|
|
|
|
|
Propably a minor bug when SQL Server has a time column?
|
|
|
|
|
|
|
Can you send me a sample SQL server database to reproduce the bug ?
my email is liron.levi@gmail.com
Thanks in advance
Liron
|
|
|
|
|
|
|
Maybe I don't know how to use the tool completely, but I am using SQLExpress directly to a mdf file. I changed the GetSqlServerConnectionString() to return my direct path to the file and it seemed to work, but maybe it would be good to add a mdf check box for people using SQLExpress files.
Thanks again for the great tool!
|
|
|
|
|
|
|
I didn't know it was possible to do that .. Maybe you can send me the connection string so I can see what you've done and add the required support to the tool ?
Thanks in advance
Liron
|
|
|
|
|
|
|
This guy has created a life saving utility. He created a utility to do what Micro-soft is not able to handle, till now.
|
|
|
|
|
|
|
Wow. This is awesome. I've been looking for a program to do MS SQL -> SQLite conversion now for hours. Found this, it does it perfectly, it's not horribly bloated like the others I've looked at. Just awesome.
|
|
|
|
|
|
|
Dear Sir,
I got a problem with some view of mine when i convert sql to sqlite db
this is a few samples of my rejected view
1.CREATE VIEW vw1_54630
AS
SELECT TOP 100 PERCENT YEAR(InputDate) AS tahun, YEAR(InputDate) AS tahun2
FROM PackingList
GROUP BY YEAR(InputDate)
HAVING (YEAR(InputDate)
ORDER BY YEAR(InputDate)
2.CREATE VIEW vw1_24000
AS
SELECT TOP 100 PERCENT TruckNo, DriverName
FROM MasterTrucking
ORDER BY TruckNo
3.CREATE VIEW vOutGroupByInc
AS
SELECT PickingDetails.IncomingNumber, Outgoing.PartNumberSW, Outgoing.PartNumberCust, Outgoing.PartName, SUM(Outgoing.QtyPack) AS QtyOut,
Outgoing.Status
FROM PickingDetails RIGHT OUTER JOIN
Outgoing ON PickingDetails.PartNumberSW = Outgoing.PartNumberSW AND
PickingDetails.PartNumberCustomer = Outgoing.PartNumberCust AND PickingDetails.OutGoingNumber = Outgoing.OutgoingNumber
GROUP BY Outgoing.PartNumberSW, Outgoing.PartNumberCust, Outgoing.PartName, PickingDetails.IncomingNumber, Outgoing.Status
HAVING (Outgoing.Status ='C')
hope u can figured it out for me
many thanks sir
|
|
|
|
|
|
|
|
|
|
Thanks
Regarding the TOP 100 issue - since the tool is not that sophisticated as to automatically convert the SQL Server T-SQL dialect to the SQLITE equivalent you may encounter situations when you will need to manually edit the view definition. That's why I've opened a special dialog to alter the SQL code in such cases. Same thing for triggers.
Liron
|
|
|
|
|
|
|
The error dialog was opened as expected.
You did a great, thank you for sharing the code.
|
|
|
|
|
|
|
your's tool is very good,I fand it long long time.
thanks
|
|
|
|
|
|
|
Thanks
|
|
|
|
|
|
|
Hi Liron, thanks for sharing the code. It is very organized and documented. This tool is very valuable for Android developers moving databases from SQL Server. In fact, exporting directly from SQL 2008 doesn't work fine if you move more than one table at a time. This tool does it perfectly.
Regards,
Aaron
|
|
|
|
|
|
|
Hello,
is it possible to convert SQL Geometry type to SqLite using SPATIALITE or other solution ?
regards,
Laurent
|
|
|
|
|
|
|
Maybe, at the time I wrote this library I didn't know of any spatial data types in SQLite (and still doesn't ..)
Liron
|
|
|
|
|
|
|
YOU!...are the man.
Don't know if you're taking feature requests, but I'd love to see it handle datetimeoffset datatype.
Take care,
Sean S
Seattle, WA
|
|
|
|
|
|
|
Hi Sean
Thanks for the kind words
No problem adding support ..
Can you send me a sample database file (to liron.levi@gmail.com) with datetimeoffset so I can check ?
Thanks
Liron
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Rant 
Admin