Comments
Sort by recent activity
Ah I think the documentation is incorrect. http://www.red-gate.com/supportcenter/C ... 700076.htm
This shows that ReseedIdentity is not a default option but it does appear to be. By specifying the options explicitly (and not specifying ReseedIdentity) I get the result I want. / comments
Ah I think the documentation is incorrect.http://www.red-gate.com/supportcenter/C ... 700076.htm
This shows that ReseedIdentity is not a default option but it does appear to be. By specifying the o...
Splitting the steps does introduce issues because the dependencies are not managed for me. Our current full process is:
1. Synchronise basic static data (only managed in development)
2. Add any missing row data (/include:Missing)
3. Add any column updates where the columns are not managed in production (using /ignoreColumns)
However if data is added in step 1 that is dependent on the missing rows added in step 2 then it fails. If I move step 1 to after step 2 then I have the same dependency issue but the other way around. Ideally I need to be able to run all of the above in a single go and let RedGate figure out the dependencies.
Is it likely that this can be done via the API? / comments
Splitting the steps does introduce issues because the dependencies are not managed for me. Our current full process is:
1. Synchronise basic static data (only managed in development)
2. Add any mis...
Forgot to mention, we are using the command line to achieve this at the moment.
I think I've solved this by doing a two step script generation.
1. Use /include:Missing to add any additional rows introduced in Dev and carry across all columns.
2. Use /include:Differences /ignoreColumns:MyProductionMasterColumn to carry across updates without affecting columns that are edited in production. / comments
Forgot to mention, we are using the command line to achieve this at the moment.
I think I've solved this by doing a two step script generation.
1. Use /include:Missing to add any additional rows in...
Fantastic, I can confirm it fixes my issue. Thanks for the fast turnaround. [image] / comments
Fantastic, I can confirm it fixes my issue. Thanks for the fast turnaround.
The last step should work because the preceding data migration step would have populated the columns with data. This can be guaranteed because the source data has already got the NOT NULL constraint so must have values for the additional column.
(note that I haven't yet tried the SQL Data Compare to see if it can add data for the added columns but am assuming it can - as opposed to only working on a row added or removed basis - or am I wrong about that?)
But thanks for your reply - am looking forward to this feature being added. / comments
The last step should work because the preceding data migration step would have populated the columns with data. This can be guaranteed because the source data has already got the NOT NULL constrain...
This is also a requirement for us. We use DBAmp to synchronize tables from Salesforce, we leave it up to DBAmp to manage the columns on these tables and the data but we would like to use RedGate to patch in additional indexes. / comments
This is also a requirement for us. We use DBAmp to synchronize tables from Salesforce, we leave it up to DBAmp to manage the columns on these tables and the data but we would like to use RedGate to...