migrate + convert data from old to new db structure in SQL 2000 with DTS

microsoft.public.sqlserver.tools

2 Feb 2006 3:55 PM

geronimo007

Hi, I want to migrate + convert data from old to new db structure in
SQL 2000 with DTS.

The important thing I have to do is manage the transformation (not just
a copy of data and structure), it is a transformation of data for use
in a new/changed db....

I can manage the transformation in DTS with script like VBscript or
javascript.

Is it possible to do the transformation with other tools? Selfmade
programs in c#? Or is the linking with DTS not possible and is the only
solution the use of vbscript/javascript (activeX?)?

Or are there other tools (not DTS) that can help me?

All kind of information is welcome,

Greetz,
JC