Changing from testDB to productionDB coming from mongoDB

[Anonymous]

I've made a connection with a mongoDB, which has given me 35 tables. I've found the way to manually change all these table from test to production, but considering I might have to do this multiple times, I need this to be automated.

When I change the source, it doens't change the schema, forcing me to edit all the tables in the advanced editor. 

My question is twofold:

1) Can I change the source and schema at the same time (by just changing source or some other button?)

(replace all => "alinktst" to "alinkacc")

2) Can I change this in bulk for all my (35) tables?

ref.: when changing source, before:

after: 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

The answer is yes for both questions. BTW, I suggest you to use parameters to change datasource. Please refer to the case.