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

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
e.g.

In local Dev environment:

pusqlserver 127.0.01

In Production environment:

pusqlserver SQL_SERVER_IP
    • Related Articles

    • Power Update Maintenance

      Power Update is sold by a one-time fee that gives users a perpetual license to use the software forever. PowerON offers an optional maintenance contract in order to receive updates for the software. ​ Purpose of the document In this article, you will ...
    • Troubleshooting Excel PowerPivot Update

      If you are using Excel 2010 and Power Query and have an issue during UI Automation, or if the task succeeds but the data doesn’t update please refer to the related article. Otherwise please check the error messages in the ...
    • Power SQL Update not loading in Excel

      Search the registry under both Current user and Local Machine for: PPSQLConnector and set the LoadBehaviour to 3 at all occurances e.g.: If the above doesn't resolve the issue, search for Addins in the registry under both Current user and Local ...
    • Save Datasource Password

      Option 1 (only works with PowerPivot datasources): Set the datasource password in Option\Datasource Passwords Make sure that the DS Name matches exactly the name of the PowerPivot datasource under Existing Connections in PowerPivot For this setting ...
    • Power Update Command Line Parameters

      Running PU jobs in a batch file: After you have defined the jobs, you can take even more control over the jobs by i.e. running them sequentially in a batch job. Here are the command line parameters supported:  PQRefresh.exe command line (normal ...