• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

SQL SERVER 6.5

How to copy all the databases from one of the SQL Server to the other SQL Server
0
yavanthi
Asked:
yavanthi
1 Solution
 
Darren_SimonsCommented:
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
 
yavanthiAuthor Commented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now