NexusDB to SQL Server

[NightStalker-DNS]

Hey guys

I need your help. I have a nexusDB database and SQL Server 2000. I need the nexusDB databases changed into a format supported by SQL and import it into SQL. Oh, nexusDB and SQL are on seperate servers.

How could i accomplish this?

Thanks alot

[asterix]

This is a two-stage process:

1) Dump the data from nexusDB into text files
2) Import the data from the textfiles into SQL Server

To do 1)
I have no idea, and I read the user guide. Page 76 mentions "Export", but not how to do it.

To do 2)
You can use the bcp.exe utility.
Or you can import data directly using the ODBC Text engine
Or you can use a DTS packet to script the import.

Try asking the developers how to export the data.

[asterix]

Some more information for you.

I have not used nexusDB, so I am flying blind here, but you could try importing the data directly from SQL Server by connecting to the nexusDB server using ODBC.

Of course, you need to be able to make a TCP/IP connection between the two servers. As dar as I can tell nexusDB supports ODBC.

[NightStalker-DNS]

Hey, thanks for the help

I have a ODBC driver 4 nexusDB on the server running SQL, so i guest that would be the best bet, but my problem now is to do this all in code at specific times....

Oh well, thats for the dev guys to answer.

Thanks again