Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Unanswered: Stored procedure

    Hi All,

    Is it possible to write a stored procedure in MS SQL server to import the database from sybase to MS SQl server.(The same way the DTS does)
    Basically all our customers have sybase database and now it has to be changed to SQL server and I have to write a stored procedure in SQL server to do the import from sybase to sql server.

    Any help is appreciated.
    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Anything you can imagine is possible.

    Most things you can imagine are not practical.

    A single stored procedure that will migrate an entire database from Sybase to SQL Server? Don't even go there...

    Look for a third-party utility to help you out, or just put on your waders and point yourself in the direction of the swamp.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's wrong with DTS?

    You could always look at:

    http://weblogs.sqlteam.com/brettk/ar...6/17/1618.aspx
    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.

  4. #4
    Join Date
    Sep 2003
    Posts
    364
    Microsoft makes a free Sybase to SQL Server migration tool. It utilizes DTS and is available in the resource kit on the SQL Server 2000 cd's. I haven't used it in a production capacity but it seems to work pretty good.

Posting Permissions

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