Change Data sources in queries

[wyconian]

Hey everyone

I have a model in dev that is currently pointing to connection A, I need to repoint all the import layer queries to connection B but I can't chaneg connection A in the portal because there are other models using it.

I've added connection B in the portal and as a data source in my model.  Querstion is; does anyone know of a quick way of updating all the import layer query subjects to point to the new data source?

I could manually go through the queries and change them but there are more than 2k queries?

As always any help appreciated

Simon

[eliza_jane]

Back up your cpf file and open it up in notepad and do a find and replace on your data source.

[IceTea]

Maybe you open the Model file in an text editor and do a "search&replace"?

[wyconian]

Both - thanks for your help that was a whole lot easier than I thought it was going to be  :)