IT WORKS !
Thanks for all the various help. !
Last fixes were editing Data Source connection strings and some views & functions hardcoded with linked server names.
Thanks for posting back...think we all should go have a drink now.
Sue
Indeed!
Do a copy/paste of my earlier post for the process, save it in a text file and put it in your script folder (which is also in source control, right?)
Trust me, you will be doing this again
Yes, I have saved much of the info in this thread...Thanks