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 |
|
jayram11
Yak Posting Veteran
97 Posts |
 Posted - 2010-07-28 : 11:27:52
|
| Hii have 2 SQL servers and they are SQL 2000 and i want to replace DATABASES in one with another. Basically they should look the same. how do i do it in management studio. i have sql 2008 on my desktopthanksjay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jayram11
Yak Posting Veteran
97 Posts |
Posted - 2010-08-02 : 11:30:36
|
| i want to not just detach and attach one database but rather replicate the databases in one server on to another. Under both the SQL servers, i have databases, security, server objects, replication, management and sql server agent. i want both the servers databases content and structure to be the same. EG:) under server A, i have databases and there are 50 databases and each databases have different number of tables, unders server B, i have databases and there are 60 databases and each have different number of table. i want databases under server B be the same as databases under server A..i hope i made myself clear....i have sql server 2008 on my desktop and both servers are sql 2000thanksJay |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-02 : 11:47:13
|
| one time, or they need to stay in synch?either way, what Tara said is still the way to do it. Backup all the databases on A and restore them to B.then if they need to stay in synch, you can use transactional replication to keep everything synched up. |
|
|
|
jayram11
Yak Posting Veteran
97 Posts |
Posted - 2010-08-06 : 10:37:46
|
| Thanks |
|
|
|
|
|
|
Replacing DATABASES in one server from another