I could not make synonyms work with Entity Framework 6, so converted to using dated schema names (E.G. DYYYYMMDD) and create my new tables in the new dated schema. When...

I ended up cloning the tables to be updated into a different schema, then updated EF to be able to open two DbContexts for the databse, one for each schema,...

I had not heard about DB synonyms before which seem a great feature for this problem. I guess you keep the state as to which table is current elsewhere in...

Nice. Thank you!

Kevin, I figured out that last 'onsies w/ EF' part already so thanks so much for the suggestions and alternatives to doing that. Dave

Thanks Kevin.

Since I am doing all this in code, not SSMS, is there any better way SQL way I can access programmatically to clone a table including data, indices...