If DTS is not supported in the new Workgroup version of SQL 2000, how does
one get data and SPROCs in and out of a server? Is there some
replication-like process to transfer from one SQL site to another without all
of the transfomation capabilities of DTS?

I cannot find any feature list for SQL 2000 Workgroup, so cannot see what
the state of DTS is within the product. Based on the 2005 features Workgroup
supports the Import/Export Wizard.

Does it support replication? That is a replication-like process!

For data you could also look at BCP or Bulk Insert. For full data transfer
capabilities then you may well need a higher edition, after all that is what
editions are all about.

For procedures, how about just using scripts? Much better for managing and
controlling code deployments than DTS ever was.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"mtncruzr" <mtncruzr (AT) discussions (DOT) microsoft.com> wrote