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 |
|
don_marko
Starting Member
5 Posts |
 Posted - 2009-03-02 : 08:39:45
|
| I have got 2 databases on different servers. One with blob fields. I need to merge this databases into one with all data. How to make it? |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-03 : 01:16:55
|
| Restore one database thenfor Tables: Use SSIS or Import/Export wizard to inport data from second database. To get all changes made upto the second and make the database unaccessible for others after starting of the copying process you may alter the databases in single user mode. Keep in mind the order of tables when importing if foreign keys exist. for all other objects create sql script on first database and execute it on second database. |
 |
|
|
don_marko
Starting Member
5 Posts |
Posted - 2009-03-03 : 03:24:22
|
| Thank you. I'll try tonight \(^_^)/ |
|
|
|
|
|
|
Data bases merging