For creating SQL Server aliases use either SQL Server Configuration Manager or cliconfg.exe utility. The utility apparently exists on virtually any Windows computer. Safe way would be creating same aliases for 32-bit (System32) and 64-bit environments (SysWow64).
With aliases properly set there is no need to modify connection strings in project's configuration file when switching between different environments, e.g. development and production.
No comments:
Post a Comment