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???
- 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.
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?
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).