DBCleaner

Home > DBCleaner

DBCleaner is a project mainly written in ..., it's free.

Collection of scripts to clear out data from any populated tables in a SQL Server DB

Using the two scripts you can clear out any data from an exisiting SQL Server database.

Run 'DropAndRecreateForeignKeys.sql' to generate statements to drop and recreate all foreign keys.
Run 'GetTablesWithData.sql' to generate statements to delete data from existing tables.
Run the drop foreign key statements.
Run the delete statements.
Run the recreate foreign key statements.

Previous：ozbot