Converting a .sqlite file to MSSQL format

Question

I'm trying to do this, so far I've found a firefox addon that converts my .sqlite file to some sort of .sql create script (need some advice on what format this is, is it sqlite, but then what's the difference between this and a .sqlite file?).

I've tried executing it in MySQL and MSSQL and it won't run so I'm guessing it's some kind of sqlite syntax.

Is there anyway I can convert this .sql file so it's in MSSQL syntax to drop into my database?

Answer 1

Based on what you have written, the firefox addon is not your tool. I recommend you go with SQL Server Import and Export wizard (which is found inside your Start->Programs->SQL Server folder). There you can select the source and target databases.

But before you begin you will have to create an ODBC connection to your sqlite database. Please use the open source driver to set the ODBC connection string to your sqlite database.

Then in the SQL Server Import and Export Wizard select ".Net Framework data provider for ODBC" as a source database and type in your connection string. You will have to also nominate your target SQL Server database in the next step.

After that the wizard will provide you options to what to import