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 |
|
hbharath
Starting Member
9 Posts |
 Posted - 2007-09-10 : 10:58:02
|
| Hi, We have we had a database in 2006 with around 90 tables and later we created a new database in 2007 with more tables for same application. Now we want to have a database which will contain all records from the two above database. how should we go about this??Bharath JrDBA |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-10 : 11:04:04
|
| Do the two database have the same named tables, and same structure for each table?If so can you just "merge" the data?If the data volume is large (many MANY millions of rows) I would propose horizontal partitioning instead.Kristen |
 |
|
|
hbharath
Starting Member
9 Posts |
Posted - 2007-09-10 : 11:59:41
|
Kristen Thanks for ur tips, now the two database are production database, and the database which we want to merge record is a devlopment database. Now my work will is to compare the structure of this two database, and after identifing it populate this new databse with records from dis two database. so i would like to know using what tool can i compare this two database or any script. and then using which method shall i use like using export/import method or using DTS or any better method is dere. and ya how do we merge data in sql server can u throw some light on it to, it will be helpful to me.thanks in advance. quote:
Originally posted by Kristen
Do the two database have the same named tables, and same structure for each table?If so can you just "merge" the data?If the data volume is large (many MANY millions of rows) I would propose horizontal partitioning instead.Kristen
Bharath JrDBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-10 : 12:38:16
|
| "what tool can i compare this two database"Have a look at RedGate Compare.DTS is a reasonable tool for copying data from one database into another.Kristen |
|
|
|
hbharath
Starting Member
9 Posts |
Posted - 2007-09-10 : 15:28:05
|
| thank you kristenBharath JrDBA |
|
|
|
|
|
|
Merging two database