sql server dts: DTS in SQL 2000 Workgroup -- sql server dts

DTS in SQL 2000 Workgroup

mtncruzr
12/22/2005 5:34:02 PM

sql server dts: 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

Re: DTS in SQL 2000 Workgroup

Darren Green
12/23/2005 9:37:21 AM

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

[quoted text, click to view]