I hope I'm not to late for suggesting this kind of feature for the 8.0
But there's something i'm doing very often in each application : a table 'Parameter'.
This table hold every parameters for the application. Some of them are almost static, but some are dynamic depending on what you do with the application.
When I add new parameter in the dev database and want to push them to a production database for deploying a new version of the application, I want to synchronise these new parameters but I don't want the old parameters to be overwrite.
Now I'm using the WHERE Clause for each parameter that I don't want to be overwrite and add it manually.
I would be nice if there's a feature that could allow me to specify columns to update (like the way we select column to compare), for example
Table : Parameter
Field : ParamID, ParamValue, ParamDate
You could sync only the ParamID and ParamDate column leaving the ParamValue untouched, so that It will add new parameters but don't erase the value of old one.
Also a combinaison to this would be to have the possibility to have multiple row for one table with different WHERE Clause and column to update.
For example a little SQL Query that could represent it in my Parameter table
UPDATE Parameter SET ParamDate = @ParamDate WHERE ParamID = 'AdminName'
UPDATE Parameter SET ParamValue = @ParamValue, ParamDate = @ParamDate WHERE ParamID = 'ApplicationName'
For the parameter 'AdminName' I want to update the column ParamDate or add new rows and the parameter 'ApplicationName' i want to update all columns or add new rows
Thanks
But there's something i'm doing very often in each application : a table 'Parameter'.
This table hold every parameters for the application. Some of them are almost static, but some are dynamic depending on what you do with the application.
When I add new parameter in the dev database and want to push them to a production database for deploying a new version of the application, I want to synchronise these new parameters but I don't want the old parameters to be overwrite.
Now I'm using the WHERE Clause for each parameter that I don't want to be overwrite and add it manually.
I would be nice if there's a feature that could allow me to specify columns to update (like the way we select column to compare), for example
Table : Parameter
Field : ParamID, ParamValue, ParamDate
You could sync only the ParamID and ParamDate column leaving the ParamValue untouched, so that It will add new parameters but don't erase the value of old one.
Also a combinaison to this would be to have the possibility to have multiple row for one table with different WHERE Clause and column to update.
For example a little SQL Query that could represent it in my Parameter table
UPDATE Parameter SET ParamDate = @ParamDate WHERE ParamID = 'AdminName'
UPDATE Parameter SET ParamValue = @ParamValue, ParamDate = @ParamDate WHERE ParamID = 'ApplicationName'
For the parameter 'AdminName' I want to update the column ParamDate or add new rows and the parameter 'ApplicationName' i want to update all columns or add new rows
Thanks