Comments
Sort by recent activity
Have you guys been able to fix the bug with v3.1 that caused the permission error for non-sysadmin users? / comments
Have you guys been able to fix the bug with v3.1 that caused the permission error for non-sysadmin users?
A feature to allow simple updates would be fantastic.
I'm getting around this limitation by creating views against the source tables that select only the columns I don't want to "update". I use the Table/View generator to populate those columns in the target and randomizing generators for the columns I want to "update". The only columns for which this doesn't work are those with a Foreign Key constraint and IDENTITY columns.
2 possible enhancements to address this, which would help my situation but possibly not the other posters', are:
1. For columns with FK constraints, default to the "Foreign Key" generator, but allow us to change it to a different one.
2. For IDENTITY columns, default to the "Server Assigned" generator, but allow us to change it to another integer-type generator with an option to SET IDENTITY_INSERT ON. / comments
A feature to allow simple updates would be fantastic.
I'm getting around this limitation by creating views against the source tables that select only the columns I don't want to "update". I use th...