Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Import SQL Script in DTS - Urgent

Author  Topic 

shishi
Starting Member

7 Posts

Posted - 2003-04-10 : 05:36:16
Hi Friends ,

Theres a database name 'Trial' .
Thro' Enterprise manager , I hv generated SQL Script for 'Trial' db.

And I need to copy that 'Trial' db files
( all datas & tables etc )
into another Database 'Trial -1 ' db.
which is in another remote Server in diff place.

So from Enterprise manager within 'Trial-1' db
I went for importing Sql Script .
theres no option for importing SQL Script file .

How do I import SQL Script into another db
via DTS wizard . Pl explain step by step.

HELP , Its urgent .

Regards
Shishi

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-10 : 05:54:04
Cross Post..
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25275

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -