importing data from sybase to mssql : LUSENET : SQL Server Database Administration : One Thread


Thanks in advance

While i am importing data from sybase 12 to SQL2K using DTS I am getting tables only. I need to import all the dependencies along with the tables

What should I do ?

Is there any alternate method other than DTS


Krishna Kumar

-- Anonymous, August 28, 2004



DTS will not import the PK from sybase, only the data and table structure. Simply script out the PK definition and apply in an ExecuteSQL task in SQL Server.

Hope this helps,


-- Anonymous, September 02, 2004

Moderation questions? read the FAQ