I need either an editable SQL query or a script to copy data from one database on a production server and merge it with another production server. The project should include:
Editable Source and Destination server option.
Editable SQL logon criteria for each server.
Work on several tables within the database either using wildcards or an editable list of tables.
Edit a predetermined column with editable preset data on import to the merged DB.
Simplified instructions on locations of required editable fields if not easily evident.
The project can take any form capable of running on Windows and MS SQL 2008R2. Additional details and DBs available.