DB Maintenance Features Revision

[JustinVanRegenmorter]

As of DesignTime Revision 2014 database maintenance has been updated to give the user more capabilities. There is now a Bulk Column Addition window to allow users to add in multiple columns quickly by allowing the user to enter in multiple columns in a csv format.

Bulk Add Example.PNG (17.44 KiB) Viewed 4587 times

Bulk Add Example.PNG (17.44 KiB) Viewed 4587 times

Also, implemented the ability for users to delete, modify, and add columns to existing tables.

Database Alter Table Page.PNG (33.89 KiB) Viewed 4587 times

Database Alter Table Page.PNG (33.89 KiB) Viewed 4587 times

With these changes comes a notification on promotion for users to confirm these changes and notify them that this could result in data loss.

Database Table Alter Confirmation.PNG (38.69 KiB) Viewed 4587 times

Database Table Alter Confirmation.PNG (38.69 KiB) Viewed 4587 times