how to tranfter "Sql lite" database to "Sqlserver 2008"
Sysn framework "C#" code.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vinay SinghPosted Jun 23, 2016, 4:43 AM
Samir BhogaytaPosted Jun 23, 2016, 4:03 AM
These are the steps we will follow:
- Download an ODBC driver for SQLite
- Install the driver
- Create a System DSN for the database
- Create a linked server in SQL Server
- Select the data from the source and insert it into a SQL Server database table
Source : https://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/