MSSQL has a tool called Data Transformation Services (DTS).

Open Enterprise Manager, expand Data Transformation Services node,
right-click Local Packages. Select New Package and play around :)  Using it
is like drawing a flow chart.

You can also use C++/VB to create the package (DTS is available as COM)...
because the UI inside EM is not powerful enough - some tasks can only be
done with C++/VB.

See http://www.sqldts.com/ for resources and links about it. You may also
want to ask/search about it in Microsoft's public newsgroups.

HTH,

KC

Have a look at Scribe (www.gestalt.com/Scribe, login "guest", password
"star").
Scribe Enterprise Edition works with multiple databases; what you need is a
Process (built with Scribe) that will retrieve data from one table that
exists in database A, and insert it into another table that is located in
database B.

Alex Molochnikov
Gestalt Corporation