Home Forums SQL Server 2014 Development - SQL Server 2014 Using hardcoded database names in query when database names are different on development and production server RE: Using hardcoded database names in query when database names are different on development and production server
Steve Jones - SSC Editor
SSC Guru
Points: 734444
More actions
December 26, 2017 at 11:11 am
#1973496
Synonyms is how I'd do this, perhaps with idempotent scripts like Anthony shows. There is a PIA in terms of maintenance in that you have difference copies of the code for ServerA v ServerB, but it's minimal here.