Devart Releases dbForge Data Compare for SQL Server!

Question

Devart, the leading provider of solutions for connecting software with data and database management, has recently announced  the release of dbForge Data Compare for SQL Server.

 

dbForge Data Compare for SQL Server is a new robust tool that meets all requirements of modern data comparison and synchronization in SQL Server databases and walks you through well-known complicated situations during these processes. The new product's functionality is far from simply automating routine comparison and synchronization tasks. It is aimed at expanding your control over data handling, making it clear, accurate, and safe.

 

dbForge Data Compare for SQL Server also offers both automatic and manual (custom) mapping of schemas, tables, views, and columns, convenient view of data differences, detailed control over which data to synchronize, easy to use Data Synchronization wizard, warnings on possible data loss and various notifications, large script execution, enhanced working with data, friendly UI.    

 

The price as little as $149.95. If you want to learn more, download trial edition, or order a license please visit Devart site:http://www.devart.com/dbforge/sql/datacompare/.

 

Please, feel free to download, try and write any comments and suggestions about our products!

Answer 1

Gaurav,

Would like to understand few things.

Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.

Below link has the sample stored procedure to delete the records (result of search query) from the table.

https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx

Hope it will solve your issue.

Answer 2

Another approach you can take is schedule the deletion of rows during a time when database is not used.

Example during Night.

Then you would not need to implement any extra logic.

But use this, only if deletion can be done later.

Answer 3

CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO

Answer 4

https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes