Geek asks and answers

Conversion of the .sqlite file to the MSSQL format

I am trying to do this, so far I have found firefox addon that will convert my .sqlite file to some kind. sql create script (you need to know what format it is, it is sqlite, but then what is the difference between this and the .sqlite file?).

I tried to execute it in MySQL and MSSQL, and it will not work, so I assume this is some kind of sqlite syntax.

Is there anyway I can convert this .sql file so that it goes into my database in MSSQL syntax?

+5
source share
1 answer

Based on what you wrote, the firefox addon is not your tool. I recommend that you go through the SQL Server Import and Export Wizard (which is located inside the Start - Programs - SQL Server folder). There you can select the source and target databases.

But before you start, you will need to create an ODBC connection to your sqlite database. Use the open source driver to install the ODBC connection string into your sqlite database.

Then, in the SQL Server Import and Export Wizard, select ".NET Framework Data Provider for ODBC" as the source database and enter the connection string. You will also need to designate the target SQL Server database in the next step.

After that, the wizard will provide you with options to import

+8
source

More articles:


All Articles