Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?
Problem
Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server 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. Edit: The table columns and layouts are different so using the combo of http://www.codeproject.com/KB/database/convs…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?
The OP is asking for a way to query between DBs and so I understand the linked server responses. However, if you're here because you simply want to open an SQLite db with MSSMS, it's a lot easier than that. Call me lazy, but all of these answers are kind of laborious and/or require things you may not want to do, have access to do in every case, or are just the wrong thing to do if all you are looking for is something better than DB Browser For SQLite such as MSSMS. Just use this: SQLServerCompa…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix