After using SQLite for development and beta-testing for a home-project I want to migrate the DB to Microsoft SQL Server to get better performance. Is there any free/cheap utils that will do this?
So far I have found DBConvert that looks like a good product, are there others?
You can use the Microsoft SQL Server Management Studio to connect your SQLite data to an SQL Server instance. Linked Server is a tool of MS SQL Server that allows to execute distributed queries to refer tables stored on non-SQL Server datbase in a single query.
SQLite is generally a lot faster than SQL Server. However, SQLite only supports a single writer at a time (meaning the execution of an individual transaction). SQLite locks the entire database when it needs a lock (either read or write) and only one writer can hold a write lock at a time.
There are a few choices here: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With