I have inherited a demo db called demo_1 and a live db with +300 tables.
They are almost identical, but there has been done some work on the live db, which has not been done on the demo. Its missing primary fields, some keys, a few identity fields.
Its pretty easy to copy the live database structure to the demo, and has been done - Call it Demo_2
Now i need to copy the content from the demo_1 to demo_2.
I can of cause make it by making something like Insert from for each table, but there must be some scripting possibility, so it can be a bit faster.