Microsoft SQL Database Combine

I need to write a script that will combine two sql databases into one.
This has to be done on a regular basis so i need to make a program that will be easy enough for a user to use.

any ideas?