April 27, 2011 at 4:50 pm
I have an existing application - PowerBuilder 12.5 running on Sybase.
All is good. I now have a client that would like this app to run on MS SQL Server 2005/8.
I am both DBA and developer at this point, zero training on MSSQL - and I have at best - a 75 day turn over. Most things seem to be working fine – but running into issues with stored procs and permissions.
Can anyone recommend a good book that covers the basics of everything??
and/or a site specific to Sybase/MSSQL conversions...
Thanks in Advance 🙂
April 28, 2011 at 6:27 am
The two systems are similar but as you have found not equal 🙂
If you have managed to get a full output of the DDL for the database and code then you can attempt to implement in sql server and see what immediately crashes.
After that, it's a laborious task of manually reviewing each procedure and permission and implementing the sql server way.
There is no simple DB to DB transfer as they're all subtly different.
HTH.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply