Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL SERVER 6.5

Posted on 1998-12-23
2
Medium Priority
?
228 Views
Last Modified: 2010-03-19
How to copy all the databases from one of the SQL Server to the other SQL Server
0
Comment
Question by:yavanthi
2 Comments
 
LVL 1

Accepted Solution

by:
Darren_Simons earned 300 total points
ID: 1092361
Using the SQL Enterprise Manager you could copy each database one at a time (Tools menu / Database/Object Transfer...). Alternatively, could you not use the Database backup facility??? (I haven't tried this).



0
 

Author Comment

by:yavanthi
ID: 1092362
I had tried it and thanks for the answer. We just wanted to transfer database from one server to other and we could do it
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question