Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Migrate SQLite database to Microsoft SQL Server

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?

like image 496
Espo Avatar asked Mar 02 '10 08:03

Espo


People also ask

Is SQLite compatible with SQL Server?

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.

Which is better SQLite or SQL Server?

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.


1 Answers

There are a few choices here: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

like image 103
Trae Avatar answered Oct 20 '22 17:10

Trae