How do i make a duplicate DB that i can alter with out affecting existing system
application connects to DB1
I duplicate DB1 and call it DB2 (back up restore)
then connecte application to DB2 for testing.
my main issue so far is i nee dto duplicate schema too, when i do this my tables in DB" are called DB1.Auth etc
i need them to say DB2.Auth other wise the update script sdont work (third party)
so i after a complete copy of DB including Schema but wth a diffrent name so i can updat eit safley with out affecting the original DB and schema.