User profile for lc6529

After a lot of digging, I came up with this code, however oRedGateSession.TableDifferences.Count always returns 0 even if I delete all records from one of my tables. If I run the command line SQLDATACOMPARE /SYNC /PROJECT:"C:\Sync_Labelvision_Master.SDC" Which uses the SAME project...the tables are synced. How can I get the code to work? Sub SyncDatabases(ByVal sServerName As String) ' ' Copied From Synchronizing,Data Example In Help File ' Dim objProject As RedGate.SQLDataCompare.Engine.Project = RedGate.SQLDataCompare.Engine.Project.LoadFromDisk("C:\Sync_Labelvision_Master.SDC") ' ' Set Up Our Databases ' Dim dbMaster As New Database Dim dbTarget As New Database Dim tblMappings As New TableMappings Dim oLivedb As LiveDatabaseSource ' ' Register First DB For Comparison ' oLivedb = DirectCast(objProject.DataSource1, LiveDatabaseSource) dbMaster.RegisterForDataCompare(oLivedb.ToConnectionProperties()) ' ' Register Second DB For Comparison ' oLivedb = DirectCast(objProject.DataSource2, LiveDatabaseSource) dbTarget.RegisterForDataCompare(oLivedb.ToConnectionProperties()) tblMappings.Options = objProject.Options tblMappings.CreateMappings(dbMaster.Tables, dbTarget.Tables) Try Dim oRedGateSession As New ComparisonSession oRedGateSession.Options = objProject.Options oRedGateSession.CompareDatabases(dbMaster, dbTarget, tblMappings, SessionSettings.Default) If oRedGateSession.TableDifferences.Count > 0 Then Dim oProvider As New SqlProvider Dim oExBlock As ExecutionBlock oExBlock = oProvider.GetMigrationSQL(oRedGateSession, True) Dim stream As IO.FileStream = oExBlock.GetFileStream() Dim oBExecutor As RedGate.SQL.Shared.BlockExecutor = New BlockExecutor oBExecutor.ExecuteBlock(oExBlock, sServerName, "labelvision_master", True, "lvadmin", "lvadmin") oExBlock = oProvider.Block If (TypeOf oExBlock Is ExecutionBlock) Then oExBlock.Dispose() End If oRedGateSession.Dispose() Catch ex As Exception MsgBox(ex.Message) Finally End Try ' ' dispose of the objects to delete temporary files ' dbMaster.Dispose() dbTarget.Dispose() End Sub / comments

After a lot of digging, I came up with this code, however oRedGateSession.TableDifferences.Count always returns 0 even if I delete all records from one of my tables. If I run the command line SQLD...

0 votes

Ok, I understand the command line option and have tried to follow the examples as shown in the documentation. IE: SQLDATACOMPARE /PROJECT:C:\"Project Name" However, I could not find an SDC file anywhere! S I opened the Data Compare program and see projects listed. I right click on one of the projects and see an option "LOCATE ON DISK" I chose this option and find project files but they have names such as usmafrcadev.BoseLabels v usmafrcadev.Labelvision_Master 23-04-2007.14-24-26.6176.sdc I tried putting this name in EXACTLY, I even COPIED the name and the path the file was located on and put it in my test.bat file. I get the error Invalid File: [Path and FileName] So, I then copied the file to the root folder of my C drive and gave it a shorter name - IE: Test.SDC, I tried SQLDATACOMPARE /PROJECT:"C:\TEST.SDC" and I still get INVALID FILE C:\TEST.SDC I tried burning CD's to the software Gods but cannot get this thing to work. Do you have any other suggestions? / comments

Ok, I understand the command line option and have tried to follow the examples as shown in the documentation. IE: SQLDATACOMPARE /PROJECT:C:\"Project Name" However, I could not find an SDC file ...

0 votes

Doh! I found the problem, I am ashamed to admit it but I will post the resolution to help others. My batchfile said SQLCOMPARE /PROJECT:C:\"Project Name" not SQLDATACOMPARE /PROJECT:C:\"Project Name" Once I made the change all worked perfectly. I'm off to the eye doctor now! / comments

Doh! I found the problem, I am ashamed to admit it but I will post the resolution to help others. My batchfile said SQLCOMPARE /PROJECT:C:\"Project Name" not SQLDATACOMPARE /PROJECT:C:\"Project Nam...

0 votes

You can get around the access limitation by doing the following: #1: Setting up the Access database as a LINKED server to your SQL server. #2: Setup a SQL Database that consists of VIEWS to each table in your access database. I have done this and can sync the access database to my sql database. / comments

You can get around the access limitation by doing the following: #1: Setting up the Access database as a LINKED server to your SQL server. #2: Setup a SQL Database that consists of VIEWS to each ...

0 votes

Ok, I did that and I piped the results to a text file. I used these switches /Include:Missing /Include:Different /Include:Identical /Verbose /Sync and my report file looks like this EACH time I run it. Object type Name Records DB1 DB2 Table [dbo].[Orders] 4694 == == Table [dbo].[Orders] 20 <> <> OK Am I doing something wrong? / comments

Ok, I did that and I piped the results to a text file. I used these switches /Include:Missing /Include:Different /Include:Identical /Verbose /Sync and my report file looks like this EACH time I run...

0 votes

Yes that seemed to work! Thanks! / comments

Yes that seemed to work! Thanks!

0 votes

So I use <include>Table:\[TableName\]</include> AND <Include>Missing</include> <Include>Different</include> / comments

So I use <include>Table:\[TableName\]</include> AND <Include>Missing</include> <Include>Different</include>

0 votes

How can we help you today?

lc6529

Comments