By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,296 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,296 IT Pros & Developers. It's quick & easy.

Merge data in SQL Server 2000

P: 1
Hi,

I want to merge two databases in SQL Server 2000.

Can you help me out regarding the same.

For e.g. I have Database A and Database B, both containing the same tables and same number of tables but different data.

I want Database C to have data from both Database A and Database B.

How should I do this? what is the technique?

Also I would like to consider a case wherein both Database A and Database B are having different table structures. Then the technique to combine data from both Database A and Database B would differ. Please let me know what all things need to be considered in this case.

Please let me know regarding the same.

Thanks
Kunjan.
Jul 2 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.