Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Unhappy Unanswered: importing a sysbase database into SQL server.

    Hi

    Has anyone done this before, I have been given some flat files for a Sybase database to import into SQL server. Yet SQL server doesn't want to know. I have a .db and .log, but SQLserv er doesn't like either of them.


    However I'm not sure what to do, I have been given a .db and .log . but SQL server doesn't like either of these, is their something I should do to make it compatable? First tie I've ever look at Sysserver so please use short words, Thanks Ed

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can't restore a Sybase database onto an MS-SQL server. Your best bet is to restore the files to another Sybase server of exactly the same version/service pack (they are really persnickity about that), then use either DTS or a linked server to move the schema/data to an empty MS-SQL database.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    Right okay i think we will have to look at talking to the people who have provided the database.

    Thanks for the info!

  4. #4
    Join Date
    Sep 2003
    Posts
    364
    Microsoft has a Sybase to SQL Server migration tool. I thinks it's available in the SQL server 200 resource kit. It works really well.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Excellent point Peter! Ed really should check out Chapter 6 of The SQL Resource Kit before he goes too far with this process!

    -PatP

  6. #6
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Angry importing

    I'd use the dts utility just like if your were importing a exel file into access.

  7. #7
    Join Date
    Jul 2003
    Posts
    100
    Excellent , thanks for the help

    I like the sound of the tool in the the "SQL server 200 resource kit" The only thing is I'm not sure how to get hold of it? Do you have to order the CD or is it something I can download?

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Most of the larger bookstores stock the SQL Server Resource Kit. Drop by your friendly neighborhood Barnes and Noble, Borders, etc and you should have no problem. If push comes to shove, you can always order it online for delivery tomorrow.

    -PatP

Posting Permissions

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