Renaming Databases on the Fly

#1

Hello:

I want to use a DTS package to copy a database from one
of our remote locations to our main hub each night.
Because there is a database on the main hub with the same
name, I can't complete the package. Is there anyway to
rename the DB on the fly as I am copying it over?

Thanks,
Brennan

#2

Do you want to keep the exiting copy ?

If not then use BACKUP/RESTORE and WITH REPLACE

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Brennan" <bwashington (AT) lifestar-response (DOT) net> wrote

Quote:

Hello:

I want to use a DTS package to copy a database from one
of our remote locations to our main hub each night.
Because there is a database on the main hub with the same
name, I can't complete the package. Is there anyway to
rename the DB on the fly as I am copying it over?

Thanks,
Brennan

#3

Yes Allan:

I want to keep the existing copy because although it has
the same name, it is a totally different database.

Thanks
Brennan

Quote:

-----Original Message-----
Do you want to keep the exiting copy ?

If not then use BACKUP/RESTORE and WITH REPLACE

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Brennan" <bwashington (AT) lifestar-response (DOT) net> wrote in
message
news:011701c37c65$b0f03820$a101280a (AT) phx (DOT) gbl...
Hello:

I want to use a DTS package to copy a database from one
of our remote locations to our main hub each night.
Because there is a database on the main hub with the
same
name, I can't complete the package. Is there anyway to
rename the DB on the fly as I am copying it over?

Thanks,
Brennan

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Renaming Databases on the Fly

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Renaming Databases on the Fly - 09-16-2003 , 10:17 AM

Re: Renaming Databases on the Fly - 09-16-2003 , 10:42 AM

Re: Renaming Databases on the Fly - 09-16-2003 , 01:07 PM