How to migrate database view in an update set

mauricio23
Mega Expert

I haven't found a way to migrate database views. I've tried the following:

Update sets yields this error:

Could not find a table u_test_users_companies this update requires

What should I be doing instead?

1 ACCEPTED SOLUTION

mauricio23
Mega Expert

ok - I ended up splitting up my update sets into smaller sets. The first one being the database view piece, followed by the joins, and lastly the labels. This worked.


View solution in original post

9 REPLIES 9

Michael Fry1
Kilo Patron
u_test_users_companies = is this table in the target instance?

no - it's in the source. Although I tried to import it via XML but it's not loading for some reason.


see reply further below. ...


Anurag Tripathi
Mega Patron
Mega Patron

you are getting this error while trying to capture the db view in your update set or while previewing it to the target instance?


If latter is the case then Michael's reply is correct. u_test_users_companies table is not present in the target instance


-Anurag