Is it possible to write a stored procedure in MS SQL server to import the database from sybase to MS SQl server.(The same way the DTS does)
Basically all our customers have sybase database and now it has to be changed to SQL server and I have to write a stored procedure in SQL server to do the import from sybase to sql server.
Microsoft makes a free Sybase to SQL Server migration tool. It utilizes DTS and is available in the resource kit on the SQL Server 2000 cd's. I haven't used it in a production capacity but it seems to work pretty good.