Sybase 12.0 to SQLServer 2000 Migration

Question

Post reply

Sybase 12.0 to SQLServer 2000 Migration

Terry Bailey

SSC Enthusiast

Points: 126
More actions
November 15, 2004 at 7:16 am

#91525

I have been given the task of Migrating all our Sybase Databases to SQLServer. There are a large number of them to do. Problem is that this is not as simple as it might first seem and there are lots of nice complications like User Defined Types and those wonderful Text fields.
Of course I can use Sybase Central to extract the schema from Sybase but it all comes jumbled up and I have to unpick all the Create Tables from the Create Indexes etc otherwise my BCP loads are going to take days rather than the few hours I have.
Has anyone got any nice tools or writen some helpful scripts or programs that will take some of the hassle out of this task.
I would be grateful if anyone could make this task easier for me.
Thanks
Terry

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

See, if this helps:

http://www.microsoft.com/technet/itsolutions/migration/unix/sybsqlsv/default.mspx

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Terry Bailey SSC Enthusiast Points: 126 More actions · Answer 2

Ah thanks Frank, this looks like just the job.

It took me a bit of a struggle to get it though. Its supposed to be available via Microsoft Consulting Services, so I rang them, they didn't have a clue what it was. After looking at the documentation and the Web page for a while the Microsoft guy said it didn't actually exist. Duh!

Anyway I eventually found it in MSDN subscriber downloads, but if you arn't a subscriber to MSDN I don't know how you would get it.

Still I have now so thanks very much for the info, this looks like it could take days of editing scripts off my task.

Thanks again

Terry

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Sounds good. Glad I could help.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Terry Bailey SSC Enthusiast Points: 126 More actions · Answer 4

Wow it really is a useful tool, just converted the first database which manually would have taken me two days. I just set it running and left it overnight.

The only two issues I have found so far are

1) You have to create the target DB first and then empty it out of UDTs and defaults etc. On MSSQL this is a minor task anyway

2) We have a UDT specified as an identity in Sybase. This is not allowed in MSSQL so although the UDT was set up and the tables using it were created ok I had to manually set the column to be an Identity afterwards. Took all of 20 seconds, so no problem there.

I can recomend this toolkit to anyone who is planning to move from Sybase to MSSQL. Oh by the way suggest you use the Sybase V12.0 ODBC drivers as the 12.5 ones have a few issues around them.

Thanks again Frank