Hello Community.
I have had success posting my troubles here for help and It has paid off, so thank you all very much! ; )
I am currently having an issue that I am not quite sure how to handle. ; (
I builts a huge data model for one of our major clients; however, they have 3 different servers in which they host Dev, UTA, & Prod. The problem is that the table name change in each of them. So if I point my data model to another server where table names are different but with the same data (eg. dev or UTA), my model will fail. My initial tought of duplicating the model and pointing to a different server would not work because the query in the model will have a table name that does not match the other dev server .
So, i will have to create the model all over again for each environment dev and UTA while changing the name of the table in the query for each of them. This sound like a nightnare idea since my model is huge.
Pleaseee, if you all have any suggestion, solutions, or have run into this issue, let me know. There has to be another solution bacuse recreating the model again and manually change the name of tables in the query for each table sounds very rudimentary.
Appreciate any thoughts
Best,
; )
