There is already an object in the database
Expert
Overview
When Deploying the project, you get an error message that contains " There is already an object name 'table name' in the database ."
Applicable text of error message is:
... There is already an object named 'table name' in the database...
Before taking these steps, it is strongly advised to ensure you have a backup of your databases involved.
Resolution
Find the database that contains the table in the error message. In the case above, we were Deploying the Staging database, so you'd want to open the Staging database node of the project.
-
Right-click the database, go to Advanced , and select SQL Database Cleanup Wizard
-
The SQL Cleanup Wizard will then run.
If there are no objects to clean up you will get the following message:
No unexpected objects was found in the database.
If the Cleanup Wizard does find objects, a window will open and you will have the option of dropping objects. We recommend Right-Clicking the Project Header and selecting the Drop option.
Once you've dropped the objects, Deploy and Execute the database.
After following these steps, if you continue to get this error, you may need to recreate the database from scratch. If this is something you need assistance with, please contact the insightsoftware Support Team.