importing data from sybase to mssql

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi!

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

Regards

Krishna Kumar

-- Anonymous, August 28, 2004

Answers

Krishna,

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,

Eric

-- Anonymous, September 02, 2004


Moderation questions? read the FAQ