-
I want to open a sqlite database (filetype is .db) in Microsoft SQL Server Management studio.
asked , updated
by Octavia
-
Answers
-
answered , updated
by mmaddox_1
0While it is possible to import SQLite data into MS SQL Server via SSMS, it is much easier to access SQLite data (if that is really all you need here) using other purpose built tools such as DB Browser for SQLite or SQLite Manager (links to both below). If you actually need to import the data into an MS SQL Server database, there is a step by step tutorial (link below) on how to download and configure the appropriate drivers so that you can do this in SSMS.
https://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/