Working with two databases

Discussion in 'Databases' started by klonic, Oct 6, 2009.

  1. #1
    Hi!

    I need to fill a windows-supported database with processed data from a (Unix) Progress database (linked from the windows platform through ODBC). I'm trying to do it with SQL Server 2008 Express Edition, but I can't get out. Do you know any tool to do that, using Sql Server or any other DBMS?

    Thanks a lot in advance!
     
    klonic, Oct 6, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    jestep, Oct 6, 2009 IP
  3. Traffic-Bug

    Traffic-Bug Active Member

    Messages:
    1,866
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    80
    #3
    Have you tried DTS (data transformation services) that is part of every sql server installation?
     
    Traffic-Bug, Oct 6, 2009 IP
  4. urstop

    urstop Peon

    Messages:
    224
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I think you will have to install the necessary odbc drivers on the windows machine to use the Import or the DTS features of SQL server.

    If the data is not very huge, you might consider exporting it to a CSV file and them importing into the SQL Server from that.
     
    urstop, Oct 7, 2009 IP
  5. klonic

    klonic Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thanks all for your answer!

    jestep: although I'm trying to import data from Progress (through an already configured ODBC connection), I installed and tested Navicat, but as is supposed, it doesn't support ODBC nor Progress. I understand Progress is a not very used database, but I can't understand why they don't support ODBC.

    Traffic-Bug and urstop: DTS is only available in Sql Server 2000, and I can't find it anywhere. In 2005 and 2008 it's called Integration Services, and it's not included in the Express (free) Edition.

    urstop: odbc drivers are correctly installed and tested. I can do SQL querys from this computer to the Progress database. And yes, data is very huge. Some milions of rows. CSV is not useful...

    Any other suggestions?

    Thanks anyway!
     
    klonic, Oct 7, 2009 IP
  6. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    #6
    Why don't you try using an Access interface for it?
    I mean, you'd have 2 different ODBC connections to both databases and use the MS Access interface to migrate data from 1 place to another.
     
    shenron, Oct 7, 2009 IP
  7. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #7
    If you have millions of rows, then the CSV might even be the fastest way to do it.
    My netflix dataset 100Million rows loaded within 20-30 minutes using a CSV load option in my postgresql database.
     
    chisara, Oct 8, 2009 IP