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