Unanswered: Conversion from Sybase to SQL Server 2000
Could anyone refer me any kind of tools or process to convert from SYBASE to SQL SERVER 2000.
My complany is trying to migrate from SYBASE to SQL SERVER 2000.
Any help is greately appreciated!
While it isn't exactly a "tool" per se, the section on migrating from Sybase to SQL-2000 in the SQL Server Resource Kit is excellent. Microsoft provides a number of executables on the CD that help with the migration process too.
If you would like to convert the schema, I would recommend ErWin. We did the same conversion about two years ago, and this tool was a big help. It's also nice to have for ongoing schema changes. Though, it's not cheap.
As far as the stored procedures and such, we just did ours manually. There aren't too many syntax changes needed, so it was fairly easy.