Activity overview
Latest activity by yshteyman
This is how we implemented now. But it is now easy to maintain large single script. For instance, if one table structure change I need to search one large script and it need to be very neatly modify versus re-creating automatically using a tool one file containing ONLy one table that was changed. This change proposed for improving maintenance and avoid possible edit errors. I don't think it hurts adding 'IF EXISTS'...Thanks. / comments
This is how we implemented now. But it is now easy to maintain large single script. For instance, if one table structure change I need to search one large script and it need to be very neatly modif...
David,
We have install script shipped with our product. The install folder has script for each table and executed by controlled file listing all objects to install. In case an installation failed i want this to be re-runnable picking up from the objects it stopped. Let's say it installed all tables from A-C and failed on FK creation and exited. Next time I run install I want to skip all tables A-C and continue creating objects. I understand that i use script folder as not as intended. / comments
David,
We have install script shipped with our product. The install folder has script for each table and executed by controlled file listing all objects to install. In case an installation failed i...
How to include 'IF EXISTS' in Script Folder Generation?
I am trying to generate DDL using 'Create Scripts Folder' menu in Compare 10.2. My defaults shows checks for this option, but when I open separate script for each table in their folders it doesn't ...