Importing SQL Script File - Urgent !!

Expand Post »

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

Similar Threads

Error when running MySql Script file in Dotnet installer in C#
is there any PHP form script with file upload out there? in PHP
Execute an SQL Script in JDBC in Java
Run sql script from Patch file in C#
Importing .sql file into mysql - linux in MySQL

shishi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2003

Permalink

Apr 20th, 2004

Re: Importing SQL Script File - Urgent !!

Paste the code into Query analyzer, and run. This will create tables, etc. then use DTs to import data.

Good Luck.

Rogp

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2004

Permalink

Apr 20th, 2004

Re: Importing SQL Script File - Urgent !!

I think he is saying he has an Access DB and needs to convert the tables to SQL?

Have you looked for the solution on Technet (MSDN) - Microsoft?

I am sorry, but I haven't got access to my SQL Server at work, so I can't give you step by step instructions, but Enterprise manager does have the ability to grab the table and data from Access....but you will loose the relationships between the data. So be warned on that.

I am sure there is a script or program out there that will do it for you. Search MSDN and Google, may get a faster reply!

Once again, sorry!

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: Find and Replace

Next Thread in Database Design Forum Timeline: Web Business Inteligence

DaniWeb Message

Cancel Changes

User Name
Password