Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Violator
Starting Member
1 Post |
 Posted - 2007-08-14 : 09:02:49
|
| Could anyone possibly help me out with an issue I am having... I need to copy all my SQL2005 databases from Server1 to Server2. How can I, using SSIS, copy all the databases and not just 1 specific one (database transfer task)??? My actual task is much deeper than this, but this is the main problem I seem to be encountering and I cannot find this anywhere on the web...Over and above the what I have mentioned, is there a way to also specify a name of the target DB the copy will go through to? e.g. Server 1 has 3 instances, each one with a different copy of the same DB. I would like to copy all 3 copies to Server 2 running 1 SQL instance, but to target DB's like DB_dev, DB_prod and DB_test.The latter section is not so crucial at the moment, but the first part is really an issues I am struggling with at the moment...Any help would be greatly appreciated.Thanking You in advance!!!!! |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 10:20:14
|
| there is option of copying all databases with users and logins and everythingjust look for help in books onlineAshley Rhodes |
 |
|
|
|
|
|
Copy Multiple Databases