•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 361,913 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,560 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 10916 | Replies: 2
 |
•
•
Join Date: Apr 2003
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Apr 2004
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Paste the code into Query analyzer, and run. This will create tables, etc. then use DTs to import data.
Good Luck.
Good Luck.
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 26
Master Poster
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!
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!
Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
- can not find script file "C:\achi.dll.vbs" (Viruses, Spyware and other Nasties)
- MySql file (MySQL)
- conversion of text file into data base file (Visual Basic 4 / 5 / 6)
- Script or Batch file to load Administrators in XP (Networking Hardware Configuration)
- what to do with this .SQL script? (MySQL)
- Mouse over buttons on .js file? Urgent-help (JavaScript / DHTML / AJAX)
Other Threads in the Database Design Forum
- Previous Thread: Find and Replace
- Next Thread: Web Business Inteligence
