Power ON

            Use the same connection details for Power SQL Update in Dev and Production environments

            To use the same SQL connection in a dev and production environment, make sure the dev SQL server has the same instance name as the production one.
            Then you can use the hosts file in windows to map a server name to the actual server in each environment without having to change the connections in Power SQL update

            In local Dev environment:

            pusqlserver 127.0.01

            In Production environment:

            pusqlserver SQL_SERVER_IP
            Updated: 24 May 2017 05:13 PM
            Help us to make this article better
            0 0