Forum Discussion

gdssiqueira's avatar
gdssiqueira
Helper I
10 years ago
Solved

Switching data sources

Hi guys,   I'm sure there are different ways of doing this - I wanted to ask you guys what would be the most efficient/correct way in order to minimize rework.   I have a dataset which comes from...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Easiest way is to use the Advanced Editor in the Query Editor and just edit the Source line to point to the new DB. Would have to see your source line to tell you specifically.

     

    In the future, consider using parameters to parameterize the server name/db name.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Easiest way is to use the Advanced Editor in the Query Editor and just edit the Source line to point to the new DB. Would have to see your source line to tell you specifically.

 

In the future, consider using parameters to parameterize the server name/db name.

  • gdssiqueira's avatar
    gdssiqueira
    Helper I
    10 years ago

    Seems straighforward enough. My source line looks pretty simple Source = Sql.Database("MyAddress"). It seems that all I have to do is replace the Source line with the new DB for all queries.

     

    I will look into the usage of parameters. Thanks for the help!