Thanks for your response.
My requirement is that we need to distribute out applications to our customers and there are some old customers for whom we have given sybase and now all our old customers as well as new customers shud be given the SQL server free version. Also I need to take the schema and data from the sybase and migrate it to SQL server freeware what our clients will be distributed with.
My idea is I used DTS and did the tranfomration but it dint get the primary keys so I wrote a seperate script for that and now generated the final script in MS SQL server.From now on I am stuck I dunno how to proceed to make things easier for the end user.
Even the data has to be migrated.
I want to have everything packaged in the CD and give it to our customers.