SQLite To MS SQL or Access

-
This is the working instructions to open SQLite DB in MS SQL or Access
Creating a SQL Server Linked Server to SQLite to Import Data
The main point is ODBC Driver declaration in System DSN. After this you can link the DB to MS SQL or open it in Access as well.

The short list of steps:
  1. Install ODBC driver for SQLite (http://www.ch-werner.de/sqliteodbc/)
  2. Create a System DSN for the DB file (via C:\Windows\SysWOW64\odbcad32.exe or odbcad64.exe)
  3. Create a linked server in SQL Server

Just few remarks:
  • Don't use spaces in System DSN name - it will be a problem to work with select queries in MS SQL
  • It also opens as Access DB

  • Despite of possibility to open DB in Access, an import from Access to MS SQL was failed because there are no fields detected during export procedure. It's sad... 
  • For browsing of original file I used the recommended soft DB Browser for SQLite

Comments

Post a Comment

Popular posts from this blog

NodeJS modules shrink

-
Image
I'm a newbie in NodeJS and I'm not really familiar with all this thing of "npm". I mean, I didn't expect that just for one "npm install" I will get 10Mb of 30 different folders.  After a bunch of minutes when I processed this fact, I just realize that there are a lot of junk in those folders. They are not "compiled", let's call it this way... There are "readme" files, source files, test scripts, example applications, docs and so on!!! Many of modules has duplications of another modules inside their folders. Like “inherits”, “core-util-is”, “tedious” etc. Modules inside modules, Karl! And inside them – another modules, that already exist in other modules in the project. Whaaaaat???!!! There is an example of one of them - I'm in "node_modules" and in "bl" folder, but there is another "node_modules" folder inside it as well as "test", "readme" and all this junk here. And all of
Read more