RE: copy tables along with constraints in DTS

RE: copy tables along with constraints in DTS

 

  

If your using DTS tool, please try to import/export objects. Your problem will be solved

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Saturday, November 22, 2003 2:09 AM
To: LazyDBA.com Discussion
Subject: copy tables along with constraints in DTS


Hi All,

We are using DTS tool for importing data from one
database which is present in one server to another
present in another server. the structure and the data
is getting copied where as the constraints are not
getting copied. pls suggest me as to how should i go
about to to complete the job.

waiting for ur reply.

TIA
regards
Adil

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page