Cancel
Showing results for 
Search instead for 
Did you mean: 

HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management studio

Experimenter
Experimenter

HELP PLEASE! How do I  transfer tablefile from SQLite in plant simulation to Microsoft SQL management studio so that my microsoft sql can contain the tablefile???

5 REPLIES

Re: HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management stud

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

two steps:
- read the complete content of the sqlite table into a plant Simulation table
- use the ODBC Interface to transfer the data to the MS SQL database (you will need to setup your database as a ODBC data source first)

For the second step, you will need the Interface package.

If you use SQLite with a file, you can set up the sqlite database as ODBC data source (download a ODBC driver) and you can read it directly from your MS SQL database.

Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management stud

Experimenter
Experimenter

Hello! can i use the SQLiteDemo to set as my default database on my ODBC data source? From here, I can connect to SQL server. is it possible?

Re: HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management stud

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor
then you need to set the SQLiteDemo also as the data source in the SQLite Interface in Plant Simulation.
Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management stud

Experimenter
Experimenter

Great! But how do I set the SQLiteDemo as the data source? Been thinking through for a moment and did not manage to do it. Appreciate it!

Re: HELP! How to transfer tablefile from SQLite in plant simulation to Microsoft SQL management stud

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

set in the path in the SQLite interface, Plant Simulation will create a file (if it not exists) if you access this file with the interface (SQL). Than you need to download and install a SQLite ODBC driver. After this you can set the database-file as a ODBC data source in window (look in the windows help, how to do this).

Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net