Red gate SQL Data Compare tool is good option for what you need.

Otherwise you can use DTS/SSIS or to create your own script.

Which way to use depend on your time...

Can you give us more information what do you want to do (to synhronize data in one db comparing with other, or make union of data,...)?

Good practice is to use same collation whenever it's possible. If you have databases with different collations on the same sever use COLLATION database_default in CREATE/ALTER TABLE statement to not...

Jim, you are right. SP should give better performance. At least compilation is not needed on server side. But not only performance issue is reason to not write sql in...

Hi Lester,

Job schedule should be:

Occurs weekly, every 2 weeks on Wed, Occurs once at 1:00 AM

Hi Dimitris,

There is nothing wrong but it's a matter of good practice to place sql code inside sql and not in client code. There are lot of reason for that...