MS sql server to sybase SQL server

[TonCoronel]

Is it easy or even possible to convert a MS sql server database to an sybase SQL server database? And if it is possible how can I do that?

 

[mbalent]

I assume you would need to generate create scripts for all of the tables (including any associated triggers and indexes) as well as the stored procedures. Then create the database in Sybase and run the scripts (correcting whatever errors you might get). Once the db is set up you can use PB pipelines to transfer the data.

 

[TonCoronel]

Shouldnt this be alot easier. Because ones Syabse sql server(ASE) and MS sql server were the same system but only a different name (ms bought it from sybase).

 

[pgaec]

Some points of interest
1. Check for keywords - Ex: percent, current_time and current_date are keywords in MS SQL and not in ASE
2. Check for column lengths - SQL Server does not truncate if u attempt to insert or update a larger value,instead it errors
3.PB - SQL Server requires DWs to have group by and having clause
4.SQL Server - Order by items must apply in the select list
5.SQL Server doesnt allow aggregate fns in subqueries