I have a test company that I use for testing Extender objects. I want to completely delete all Extender objects and data in that company and start over with a clean slate, what is the easiest way to do that?
If you want to start over in Extender with no Extender objects or data, you can use the SQL maintenance built into Microsoft Dynamics GP to clear out the Extender tables.
WARNING: The following steps will delete all your extender objects and data in the company database you perform these steps in, it’s always best to make a SQL backup of any company database before mass deleting any information.
1. Login to Microsoft Dynamics GP as the SA user
2. Go to Microsoft Dynamics GP – Maintenance – SQL
3. Change the database to the company you want to start over in, and change the product to Extender
4. Highlight ALL the tables that show in the window (Press CTRL + A)
5. Check the boxes on the right that say “Drop Table”, “Create Table”, “Drop Auto Procedure”, and “Create Auto Procedure”,
6. Before you hit the Process button, double check to make sure you have the correct company selected.
7. Press the Process button and allow the process to run.
8. Log out of GP and log back in. All the Extender objects and data should be removed in the company you selected, allowing you to start over from scratch.
