transferring data between dbs on sep instances of sql server group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 24 May 2005 21:44 GMT

they want to pass data between several distinct dbs on diff server groups.
I'm way new to sql server and not sure it can be done. Help! I use
enterprise mngr to do bkups and such, but that's the extent of it.

Signature

Kelly

Reply to this Message

JT - 25 May 2005 19:35 GMT

Right click the database and All Tasks.. Export Data.. Once done you also
have the option to save your settings as a DTS package for re-use. Just be
careful about that objects you select for copy or you can easily write over
data by mistake.

> they want to pass data between several distinct dbs on diff server groups.
> I'm way new to sql server and not sure it can be done. Help! I use
> enterprise mngr to do bkups and such, but that's the extent of it.

Reply to this Message

Kelly - 26 May 2005 14:17 GMT

Thank you. Can you recommend a good book to cover all of this stuffin
enterprise mngr? It's the way I've picked up most of what I know and I
really need it!

> Right click the database and All Tasks.. Export Data.. Once done you also
> have the option to save your settings as a DTS package for re-use. Just be
[quoted text clipped - 4 lines]
> > I'm way new to sql server and not sure it can be done. Help! I use
> > enterprise mngr to do bkups and such, but that's the extent of it.

Reply to this Message