Skip to main content
Super User

Return to Answer

SSMS is just a pretty face.
Source Link
ta.speot.is
ta.speot.is
  • 14.2k
  • 3
  • 34
  • 48

You may want to create a linked server, if you have a provider for SQLite that SQL Management StudioServer will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

Here is a tutorial for MySQL, so if you can create an ODBC connection for SQLite then you will be good to go.

You may want to create a linked server, if you have a provider for SQLite that SQL Management Studio will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

Here is a tutorial for MySQL, so if you can create an ODBC connection for SQLite then you will be good to go.

You may want to create a linked server, if you have a provider for SQLite that SQL Server will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

Here is a tutorial for MySQL, so if you can create an ODBC connection for SQLite then you will be good to go.

added 206 characters in body
Source Link
ta.speot.is
ta.speot.is
  • 14.2k
  • 3
  • 34
  • 48

You may want to create a linked server, if you have a provider for SQLite that SQL Management Studio will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

Here is a tutorial for MySQL, so if you can create an ODBC connection for SQLite then you will be good to go.

You may want to create a linked server, if you have a provider for SQLite that SQL Management Studio will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

You may want to create a linked server, if you have a provider for SQLite that SQL Management Studio will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.

Here is a tutorial for MySQL, so if you can create an ODBC connection for SQLite then you will be good to go.

Source Link
ta.speot.is
ta.speot.is
  • 14.2k
  • 3
  • 34
  • 48

You may want to create a linked server, if you have a provider for SQLite that SQL Management Studio will accept.

Connect to your database and then navigate through "Server Objects", "Linked Servers" and add a new linked server. You can then use SQL Server to query the SQLite database, and compare the results directly.