Activity overview
Latest activity by sarathi.vasudevan
Duplicates are coming due to multiple parallel developments are happening at the same time frame. Schema versions needs the change, both migration scripts has it and first one will not have an issue while creating the object or column, the second one (latter version) needs to validate and if the object is not there or column is not created before then create the object or column.
I hope you understand what I am trying to explain.
Basically the solution is, if the migration file has the repeated same statements (generally this situation will not happen, but if 2 or more modules are working in parallel and trying to create same object). This can be avoided if we have the “if exists†validation statement. / comments
Duplicates are coming due to multiple parallel developments are happening at the same time frame. Schema versions needs the change, both migration scripts has it and first one will not have an iss...
Thanks David for the reply.
The reason we need this feature is, we generate the migration script from this tool SQL compare.
We have individual migration files for each version of our schema. In few migration files, the changes are repeated due to some reason (this can be avoided).
If we have this validation and creation feature will help us not to do manual massage after the script generation. This will save lot of our development timings.
-- Sarathi / comments
Thanks David for the reply.
The reason we need this feature is, we generate the migration script from this tool SQL compare.
We have individual migration files for each version of our schema. In f...
Sync Script Generation with validation
Hi,
Did this SQL compare 8 version supports check for existence and create or modify or drop objects?
This will be very useful, if you run the script again and again.
Thanks in advance.
Example:
i...