Statements execution order for Deployment script
nikos74
Posts: 10 New member
First of all,
Wishing to all of you a joyful New Year.
My source script folder contains table A. The target source script contains table A_sys and A_trxn tables. Table A contained system and transactional data was split into two tables. Finally , target source script contains a view named A based on A_sys and A_trxn. Schema compare creates first the view named A (I am getting an error due to the fact the object exists (table A) and finally created the statement for dropping the table A.
Is there any way of changing the ordering of the above statements?
Regards
Wishing to all of you a joyful New Year.
My source script folder contains table A. The target source script contains table A_sys and A_trxn tables. Table A contained system and transactional data was split into two tables. Finally , target source script contains a view named A based on A_sys and A_trxn. Schema compare creates first the view named A (I am getting an error due to the fact the object exists (table A) and finally created the statement for dropping the table A.
Is there any way of changing the ordering of the above statements?
Regards
Tagged:
Answers
Happy New Year to you.
The deployment process will generate the deployment script in dependency order, for example creating a view after it has created the dependent table or tables. However the dependency process can get this incorrect, particularly when reading from script files, as it is more difficult to obtain the dependencies between objects when reading from a scripts folder compared to a live database schema
In the example you provided, View A exists in both source and target. The deployment process will be looking to modify View A, so that the target DDL dependent on Tables A_sys and A_trxn would be changed to match the source DDL which has dependency to table A. So would need to create scripts file for table A and then modify the scripts file for View A.
Tables A_sys and A_trxn only exist in the target these two tables would dropped or removed from the scripts folder.
When reviewing the comparison results, is View A listed as existing in both but different? Or are the object listed only as existing in their own schema?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com