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

  • 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.