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
sql-server-2008
|sqlite
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