Hi,
I'm in the process of migrating several systems from SQL Server 2000 to SQL
Server 2005.
On the existing SQL Server 2000 server, I have several DTS packages, one of
which uses the Copy Database feature to synchronise data on the live box
with my development box. This is an ad-hoc function e.g. a user reports an
error, so I use the DTS package to copy the live data from the particular
database in question down to my development machine so that I can compare
"like for like", if you see what I mean. Often, errors like this are
data-specific, so I need to see exactly what the user is seeing.
This DTS package contained as many Copy Database steps as there are
databases on the server(s). This means that I could open the package and
execute one or more of them as required.
I migrated this (and the other) DTS packages from SQL Server 2000 into SQL
Server 2005 without error. In SQL Server 2005 Management Studio when I
connect to Integration Services and open up Stored Packages\MSDB\DEV, all of
the packages are there. However, when I open the one in question, I don't
appear to see the individual Copy Database components so that I can run them
individually.
Is this not the way SQL Server 2005 does things? Am I going about this the
wrong way?
Any assistance gratefully received.
Mark"Mark Rae" <mark@.markN-O-S-P-A-M.co.uk> wrote in message
news:%23z5LgPsNGHA.2920@.TK2MSFTNGP10.phx.gbl...
No-one got any ideas...?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment