Can I transfer data from lookout to microsoft sql server 2005/2008?

[RobertGuirguis]

Ok, if that doesn't work, is there a way to import the national instruments database (datasource) into mysql? I did it using excel and microsoft query and it worked. Thanks for your help in advance.

[Mike@Forshock]

The database used by Lookout is quite complicated and is in Microsoft SQL Server format.  The conversion from MS to MySQL is not that good and is not an always running solutions.  

You are getting closer to a solution.  If you have MS Office Access or OpenOffice Base you can edit, insert and test your MySQL syntax using ODBC.

Mike 

[RobertGuirguis]

So since the national instruments database is in microsoft sql format, can it be opened and viewed in microsoft sql?

[RobertGuirguis]

I have one more problem,

I don't see the national instruments odbc driver in the data sources administrator under User DSN. Do you know how I can fix this? Could it me because I'm running on windows server?

Robert

[Mike@Forshock]

Robert,

NI has code examples posted on queries to the Citadel database to get data.

To query the Citadel database their should already be a System DSN setup with the database set in the settings of Lookout.  

http://zone.ni.com/devzone/cda/tut/p/id/6668

Good luck,

Mike

[RobertGuirguis]

SQL server 2005/2008 has an import/export wizard. Can I just use that to connect to the data source (odbc)?

[Mike@Forshock]

Robert,

Maybe we need a few more details on how you want to use the data.  Virtually any data analyzing and reporting can be done using the native database.

Mike

[RobertGuirguis]

All I want to do is view the data from the citadel database in sql server 2005/2008 the same way as in microsoft query. Thanks

[Mike@Forshock]

OK. Use the link I provided in the previous post it contains all the necessary syntax to query the database from Microsoft Query, Excel Access and other tools.

There is no need to send the data to MySQL or another database unless you are doing additional archiving or very specific functions that the Citadel/MS SQL database cannot.

If you have a time frame you need to have this accomplished and need more direct help I can provide my services to you, http://scada.forshock.com which you found earlier.

Thanks and good luck,

Mike

[RobertGuirguis]

I really need to view it in either sql server or mysql, and the data source is not set up correctly, meaning I cannot see the odbc driver in the data sources administrator. I know that you can import data source in sql server.