Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Posts
    95

    Unanswered: convert from db2 to sqlserver

    I have an application running in db2 udb v7.2 fp7. there are 76 tables for this app. i want to convert all these tables over to sqlserver 2000. what is the easiest method to get the data from db2 to sqlserver??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It depends on easiest for who...

    Is the schema complex or simple (foreign keys, constraints, etc)? What is the DB2 device topography? Are there 100 rows of data, or 100 billion?

    Too many questions!

    -PatP

  3. #3
    Join Date
    May 2002
    Posts
    95
    I am going to reinstall the app in sql server. the files are not large a couple thousand rows is the largest. i just want to move the data. the ri is good, as they sit in db2 currently.

  4. #4
    Join Date
    Jun 2005
    Posts
    85

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There is actually a tool in the SQL Server Resource Kit that does a pretty good job. You might want to check it out.

    -PatP

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why would anyone want to move away from DB2?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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