|
Home > Archive > MS SQL Data Warehousing > May 2005 > transferring data between dbs on sep instances of sql server group
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
transferring data between dbs on sep instances of sql server group
|
|
|
| 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.
--
Kelly
| |
|
| 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.
"Kelly" <Kelly@discussions.microsoft.com> wrote in message
news:77A81797-3DDA-45C8-8A94- 345061516ACD@microso
ft.com...
> 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.
> --
> Kelly
|
|
|
|
|