November 20, 2023 at 1:24 pm
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.
Best regards
Edvard Korsbæk
November 20, 2023 at 1:32 pm
Why not just make a backup of demo_1 and restore it over the top of demo_2?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 20, 2023 at 9:11 pm
If i just backup/restores they get identical.
But i think that what i will do is to make a script of demo_1 and demo_2, and use Ultra Compare to find out how many differences there are. I have found one important in excactly thw place where i try to solve something. Demo_2 has a primary field and key, which demo_1 has not, and they behave of cause different. But I do not think that there is many, and I can take care of them after the restore proces.
So, problem solved I think.
Best regards
Edvard Korsbæk
November 20, 2023 at 10:13 pm
Comparison tech is the way to do this. I'd suggest SQL Compare, but any tool that does this will help.
Disclosure: I work for Redgate Software
December 6, 2023 at 4:27 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply