Update, Insert but not Delete

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Update, Insert but not Delete

Postby ryolatl@hotmail.com » Wed Aug 31, 2011 5:03 pm

I compare two database.

DB Source and DB Target,

what I'm doing is Insert or Update the records that from the DB Source to the DB Target but at some point the DB Source is going to be deleted.

With the Code that I have now If I do this, all the DB Target is deleted as well and I don't want this.

What I need is to be able to Insert, Update but not Delete, Could you point me in the right direction?

thanks

this is the code that I'm using for the Execution.

Dim provider As New SqlProvider
Dim block As ExecutionBlock
Try
block = provider.GetMigrationSQL(session, True)
provider.Options.SqlOptions.

txtResults.Text += "The synchronization SQL contains " & block.LineCount & " lines in " & block.BatchCount & " batches"

txtResults.Text += "The SQL to be run is:"
txtResults.Text += block.GetString()


Dim needStream As Boolean = True
If needStream Then
Using stream As Stream = block.GetFileStream
'we can access the SQL in a memory efficient manner by accessing the underlying stream
End Using
End If

Dim executeSql As Boolean = True
If executeSql Then
txtResults.Text += "Updating target database"
Dim executor As New BlockExecutor()
executor.ExecuteBlock(block, "10.202.1.111", "Sync_target", False, "user", "pass")
Else
txtResults.Text += "Skipping: Updating target database"
End If

Finally
block = provider.Block
If (TypeOf block Is ExecutionBlock) Then
block.Dispose()
End If
session.Dispose()
db1.Dispose()
db2.Dispose()
End Try
ryolatl@hotmail.com
 
Posts: 3
Joined: Tue Aug 30, 2011 4:12 pm

Postby Chris Auckland » Fri Sep 02, 2011 11:37 am

Thanks for your post.

I think I would probably use a selection delegate with GetMigration()

e.g.
Code: Select all
block = provider.GetMigrationSQL(session, new SelectionDelegate(this.ExDelete), true);


With a method to loop through the results store and deselect all the deletes, e.g.


Code: Select all
protected bool ExDelete(SynchronizationRecord syncRecordObject)
        {
            Reader resultsReader = m_TableDifferences[syncRecordObject.TableName].ResultsStore.GetReader(Row.RowType.All);

                Row myRow = resultsReader.GetRow(syncRecordObject.Bookmark);

                // if the row is only in the target database, deselect from sync.
                if (myRow.Type == Row.RowType.In2)
                {
                    return false;
                }

            return true;
        }


I hope this helps point you in the right direction.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests