Hi,

How can I transfer all my DTS metadata services packages from on server
to another.
All connections used in those packages that point to the old server
should be changed as well.

Any help?

Thanks

http://groups.google.co.uk/groups?as...005&saf e=off


"miguel.salles" <miguel.salles (AT) gmail (DOT) com> wrote

Hi,

I discovered that it is quite different to migrate Local Packages then
Metadata packages.

I have found two ways:

I used the Transfer Packages Sample Application here Adapted for
repository packages.
Tools & Tasks
(http://www.sqldts.com/default.aspx?272)

I also migrated it by copying the content of my RTBXXXXXXXXXX tables on
MSDB database and then altered the connection by hand.

I think the best way to acomplish this is to migrate the content os the
RTB tables and then use the appl to change all connections for I
believe that with this procedure I'll will not lose any version or
other info about my DTS Metadata Services packages since the two
servers I use are identical but in the name. I havent acomplish it yet,
but I'll give it a try today. I guess there will be a lot of work until
my metadata becomes available again.

Is there no better way? Like backup up all data from MSDB ans user
databases and restore it on the other server? Can this be acomplished?
Can I restore a msdb database from one server to the other?

Thanks a lot