importing data from sybase to mssqlgreenspun.com : 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
-- 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