Is it possible to open a sqlite database from within microsoft sql management studio?

Posted by Brian T Hannan on Super User See other posts from Super User or by Brian T Hannan
Published on 2010-05-07T16:00:52Z Indexed on 2010/05/07 16:09 UTC
Read the original article Hit count: 223

Filed under:
|

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio?

Right now we have a process that will grab the data from a microsoft sql server database and put it into a sqlite database file that will be used by an application later on.

Is there a way to open the sqlite database file so that it can be compared to the data inside the sql server database ... using only one sql query?

Is there a plug-in for microsoft sql management studio? Or maybe there is another way to do this same task using only one query.

Right now we have to write two scripts ... one for sql server database and one for sqlite database ... then take the output from each in the same format and put them each in their own OpenOffice spreadsheet file. Finally, we compare the two files to see if there are any differences. Perhaps there's a better way to do this.

P.S. Alot of applications use sqlite internally: Well-Known Users Of SQLite

© Super User or respective owner

Related posts about sql-server-2008

Related posts about sqlite