From Sybase to SQL Server 2000

Question

From Sybase to SQL Server 2000

Raed-221749

SSC-Addicted

Points: 442
More actions
September 7, 2005 at 1:35 pm

#89757

Hi
How can I transfer the Database (db) from Sybase to SQL Server2000??
September 12, 2005 at 8:00 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sswords SSCrazy Eights Points: 8207 More actions · Answer 1

We did this last year with the assistance of a vendor. They had a custom utility to do it, but basically all this did was run a bunch of BCP statements that copied out all the database objects then upload them to SQL Server. I had a bunch of custom stored procedures that also had to be copied out and restored.

I believe you should be able to do this using DTS as well. There's also a Microsoft article on this subject here: http://www.microsoft.com/sql/evaluation/compare/sybase.mspx

Hope this helps.

My hovercraft is full of eels.

sswords SSCrazy Eights Points: 8207 More actions · Answer 2

Another thing I thought of just now after posting (and sushila, I am not trying to boost my post count )...

Depending on the version of Sybase that you're using, you might experience problems if you copy over stored procedures as we did. In particular, I had a bunch of legacy ones set up to support some automated Crystal Reports where the syntax had to be changed for most all of them that used date criteria. We fixed a lot of these just by pasting the Sybase version of the sp into the Query Analyser and then used it to find out where the sp would choke. I did this way ahead of the production conversion on a development server and it saved tons of time and grief.

My hovercraft is full of eels.

Raed-221749 SSC-Addicted Points: 442 More actions · Answer 3

Thanks a lot for your replies (and no problem if you want to increase your post count &nbsp

sswords SSCrazy Eights Points: 8207 More actions · Answer 4

It's sort of an inside joke. On another thread I tried to post when we were having some problems with our ISP. Then when I looked again, I had three copies of the same post and she ribbed me a little about it. Some days you just wish everything had an 'Undo' button, you know?

Best of luck with your conversion. I can't tell you how much eaiser support has been for our app since we moved over. The old Sybase box was a mid 90's AS400 that made me nervous just looking at it, never mind trying to actually fix something. Now we're on an Intel based HP server that I built from the ground up and I'm much more comfortable with that.

My hovercraft is full of eels.