How to Merge databses with same schema and different data???????

Question

Post reply

How to Merge databses with same schema and different data???????

ahmed.net

Mr or Mrs. 500

Points: 557
More actions
September 22, 2010 at 12:06 am

#140819

I have 10 databases with same schema and different data.
Now i want to merge them all in one database. but its is not just select and insert i also have to perform some operations after selecting from source database and inserting into the destination database.
What is the best way to do this ?
Please guide me ....
Thnx in advance

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Oliiii SSCertifiable Points: 5328 More actions · Answer 1

Have a look at SSIS, it should be the perfect tool for you.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

I'd agree that SSIS is probably the best way to go, depending on what the processing is that you need to do. Are all the databases on the same server?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question