SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Mentor NightStalker-DNS's Avatar
    Join Date
    Jul 2004
    Location
    Cape Town, South Africa
    Posts
    2,873
    Mentioned
    44 Post(s)
    Tagged
    0 Thread(s)

    Question NexusDB to SQL Server

    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

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  3. #3
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    SitePoint Mentor NightStalker-DNS's Avatar
    Join Date
    Jul 2004
    Location
    Cape Town, South Africa
    Posts
    2,873
    Mentioned
    44 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •