- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 09:21 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 12:03 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 09:38 AM
u_test_users_companies = is this table in the target instance?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 10:07 AM
no - it's in the source. Although I tried to import it via XML but it's not loading for some reason.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 11:50 AM
see reply further below. ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2015 09:41 AM
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