Migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000

How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000? Thanks in advance!
1.tools
2.tips
3.problems
I've never performed a Sybase -> SQL conversion, but I can inform you that
MS developed a Sybase->SQL Server migration kit / resource kit which is
available for download from the MS site if you're a MSDN subscriber. The
download is approx 570Mb in total but is was released on CD at one point.
Regards,
Greg Linwood
SQL Server MVP
"Julia" <julia.yu@.acs-inc.com> wrote in message
news:BE0F3811-4927-4650-8F01-9941BAF25BC2@.microsoft.com...
> How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000?
Thanks in advance!
> 1.tools
> 2.tips
> 3.problems
|||We recently migrated our product from Sybase ASA to SQL 2000.
Most of our major rewrites were due:
1. Triggers work very differently. There are no row-level triggers in MSS
2. Functions cannot be invoked from procedures in MSS.
Most of the other issues were related to syntatical differences.
Amol.
"Julia" <julia.yu@.acs-inc.com> wrote in message
news:BE0F3811-4927-4650-8F01-9941BAF25BC2@.microsoft.com...
> How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000?
Thanks in advance!
> 1.tools
> 2.tips
> 3.problems
|||I really appreciate your response.
I would like to know how to make/change table owner from 'dbo' to
'julia' for all tables? I only know to use sp_changeobject_ownner to
change one table each time.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||I am not aware of any way to change the owner of all the objects in a single
command.
If you post this on microsoft.public.sqlserver.programming you will get a
better response. Most of the SQL Gurus reside there.
Anyway back to your question, I would try to write a small script that would
loop through sysobjects table to get all the tablenames using a cursor and
run sp_changeobjectowner on it.
BTW, In my previous post I said functions cannot be invoked from procedures.
Its the other way around. Procedures cannot be invoked from functions. Sorry
for the typo.
Amol.
"Julia Yu" <julia.yu@.acs-inc.com> wrote in message
news:%23I4qrbiLEHA.1032@.TK2MSFTNGP12.phx.gbl...
> I really appreciate your response.
> I would like to know how to make/change table owner from 'dbo' to
> 'julia' for all tables? I only know to use sp_changeobject_ownner to
> change one table each time.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!