Transferring both Tables and relationships

#1

Is there a way to transfer by DTS both table definitions as well as the
relationships from one database to another?

#2

You can use the transfer objects task.
Depending on the amount of this you want to transfer it may be easier just
to do BACKUP/RESTORE

--
--

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

"Suresh Kumar" <skumat@pcdiDOTcom> wrote

Quote:

Is there a way to transfer by DTS both table definitions as well as the
relationships from one database to another?

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

Transferring both Tables and relationships

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

Transferring both Tables and relationships - 12-01-2003 , 12:44 PM

Re: Transferring both Tables and relationships - 12-01-2003 , 01:08 PM