In order to recover lost table with ApexSQL Diff, follow these steps: It detects differences between database objects, generates comprehensive reports and synchronizes databases, database backups, snapshots, script folders and source control projects. This is another method where a database backup is necessary, but it doesn’t have to be restored to recover lost tables due to Drop table operation.ĪpexSQL Diff is a SQL server comparison and synchronization tool for SQL Server databases. Also, if the database is large, backup restoration can be time-consuming. This method is simple and straightforward, the only setback being that it is not applicable if there’s no database backup. Run the script against the original database The script creates the dropped table first, and then inserts the dropped records: Once the script has been generated, it can be opened, reviewed and modified.
Note that a table cannot be dropped without removing the referencing constraint or the table first Generate script for dependent objects – to script the objects that depend on the dropped table.In the Set scripting options tab, choose between the Single file or Single file per object files to generate options, and specify the file path and name: In the Choose objects tab, switch to the Select specific database objects option and select the dropped table: In SQL Server Management Studio, right-click the database, select the Tasks sub-menu and then the Generate scripts command: If there is a full database backup or a chain of differential backups containing the dropped table:
0 kommentar(er)
