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 |
|
gujadra
Starting Member
1 Post |
 Posted - 2010-03-03 : 16:57:57
|
| Hi, I have 30 diferent copies of the same database, same schema that is, from a legacy system that is used in diferent locations. I need to merge all the records into a single database resolving possible conflicts. The resulting database will be queried to obtain diferent reports.I have all the mdf's files and I'm using MSSQLS 2005My question is, what do I use to do that? Integration services? Replication? Transact sql? something else?I would appreciate some guidance in this issue. Thanks. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-03-03 : 17:23:16
|
| First thing is to get all those redundant copies of data as close to each other as you can - on to same instance. Then you can run cross database queries and find out the duplicates and remove them. You can use SSIS to get all the data into one instance or even just backup/restore all databases...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-04 : 04:46:59
|
quote:
Originally posted by gujadra
Hi, I have 30 diferent copies of the same database, same schema that is, from a legacy system that is used in diferent locations. I need to merge all the records into a single database resolving possible conflicts. The resulting database will be queried to obtain diferent reports.I have all the mdf's files and I'm using MSSQLS 2005My question is, what do I use to do that? Integration services? Replication? Transact sql? something else?I would appreciate some guidance in this issue. Thanks.
Create a new database.Disable all constraints and use SSIS to export all data into this new database...enable constraints. |
|
|
|
|
|
|
Merging database