December 13, 2011 at 1:53 am
Could someone please assist, I need to combine 5 databases on seperate servers into one database on a regular basis appending the data to the tables in the single database.
Does anyone have any ideas how I could go about this.
I would really rellay appreciate the help
December 13, 2011 at 2:00 am
Best solution is replication, Setup a replication made 5 SUBSCRIBERS for the DB need to merge as ONE from FIVE PUBLISHERS.
December 13, 2011 at 2:06 am
Thanks a lot for that, I'm actually looking for another way besides replication. For some reason they dont want replication to be done, is there any other way besides replication.
December 13, 2011 at 2:09 am
SSIS has solution but need to check...how much it will help full...
December 13, 2011 at 2:13 am
Please let me know if you find something I be very grateful
December 13, 2011 at 2:17 am
SQL_Student (12/13/2011)
Please let me know if you find something I be very grateful
SSIS would be a good idea subject to your skill level on this tool. If you never worked on it it's a good opportunity to learn it.
December 13, 2011 at 2:45 am
We can do in SSIS, Just I have tried in other way, What I have done here I merged the table contents, It allowed me to do so. In your case you can use one more layer in between where you can save files as flat file destination then finally import all those to a destination.
>> Save the package as DTSX
>> Schedule a job to run the package.
December 13, 2011 at 2:50 am
That Looks good, although will the data append itself to the db, wont it cause duplicates to be created just asking thanks sooo sooo much for the assistance you are giving
December 13, 2011 at 3:01 am
Data part we have to deal , there are multiple options to deal. But as its an example my destination table was empty. In case we are discussing either we need to drop and re-create using script nor we need to check the data inserted previously and start from that point.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply