SqlData Compare question

sandu

Hi
I am trying to synchronize Some Tables from DB A with DB B
I am usinng the folowing Argfile:
<?xml version="1.0"?>
<commandline>
<out>log\DataNoga_CurrentVersion_VS_Noga_Unitest_II.out</out>
<database1>noga_Currentversion</database1>
<server1>noga-db</server1>
<database2>Noga_Unitest_II</database2>
<username1>sa</username1>
<password1>budvph,uj</password1>
<username2>sa</username2>
<password2>budvph,uj</password2>
<server2>noga-db</server2>
<!--exclude objecttype="Table" /-->
<include objecttype="Table" matches="tbl_BR"/>
<exclude objecttype="Table" matches="tbl_BRerat"/>
<ignoreidentical>yes</ignoreidentical>
<include objecttype="Table" matches="tbl_Bank"/>
<include objecttype="Table" matches="tbl_BatchInterfaceManot"/>
<include objecttype="Table" matches="tbl_CheshbonSeferRashi"/>
<include objecttype="Table" matches="tbl_CheshbonSeferRashiLeDochLaOtzar"/>
<include objecttype="Table" matches="tbl_DocumentDef"/>
<include objecttype="Table" matches="tbl_DocumentDefForDocumentSituation"/>
<include objecttype="Table" matches="tbl_DocumentForSYObject"/>
<include objecttype="Table" matches="tbl_ErkeyMadad"/>
<include objecttype="Table" matches="tbl_HitpalgutGilLEfiSugChaluka"/>
<include objecttype="Table" matches="tbl_HitplgutVetekLefiSugChaluka"/>
<include objecttype="Table" matches="tbl_IshurIdkunStatus"/>
<include objecttype="Table" matches="tbl_KishurLeSeferRashi"/>
<include objecttype="Table" matches="tbl_KvutzatBankim"/>
<include objecttype="Table" matches="tbl_medina"/>
<include objecttype="Table" matches="Tbl_Merchav"/>
<include objecttype="Table" matches="tbl_Migzar"/>
<include objecttype="Table" matches="tbl_MosadotBeMasav"/>
<include objecttype="Table" matches="tbl_ParameterLeChishuvTsua"/>
<include objecttype="Table" matches="tbl_ParameterLeDochLaOtzar"/>
<include objecttype="Table" matches="tbl_ReportHandlerDef"/>
<include objecttype="Table" matches="tbl_ShaareMatbea"/>
<include objecttype="Table" matches="tbl_Snif"/>
<include objecttype="Table" matches="tbl_SnifimMutarimLeBank"/>
<include objecttype="Table" matches="tbl_SugeyChnLeBank"/>
<include objecttype="Table" matches="tbl_SugeyPeulaBeBachan"/>
<include objecttype="Table" matches="tbl_SYBatchInterfaceDef"/>
<include objecttype="Table" matches="tbl_SYBatchInterfaceTables"/>
<include objecttype="Table" matches="tbl_SYBatchProcessCounterDef"/>
<include objecttype="Table" matches="tbl_SYBatchProcessDef"/>
<include objecttype="Table" matches="tbl_SYBatchProcessInterfaceDef"/>
<include objecttype="Table" matches="tbl_SYBatchProcessParameterDef"/>
<include objecttype="Table" matches="tbl_SYDocumentSituation"/>
<include objecttype="Table" matches="tbl_SYNumerator"/>
<include objecttype="Table" matches="tbl_SYObject"/>
<include objecttype="Table" matches="tbl_SYPrintoutHistory"/>
<include objecttype="Table" matches="TBL_SYReportColumnDef"/>
<include objecttype="Table" matches="TBL_SYReportDef"/>
<include objecttype="Table" matches="TBL_SYReportGeneralFieldDef"/>
<include objecttype="Table" matches="tbl_SYReportGeneratorDef"/>
<include objecttype="Table" matches="tbl_SYReportGeneratorParameterDefaults"/>
<include objecttype="Table" matches="tbl_SYSystemCodes"/>
<include objecttype="Table" matches="tbl_TatKvutzaLeChishuvTsua"/>
<include objecttype="Table" matches="tbl_TavlatHachlataLesivugPeulot"/>
<include objecttype="Table" matches="tbl_TBPianuach"/>
<include objecttype="Table" matches="tbl_TBTableCodes"/>
<include objecttype="Table" matches="tbl_TedirutLeChodesh"/>
<include objecttype="Table" matches="tbl_Yeshuv"/>
<include objecttype="Table" matches="tbl_YomAsakim"/>
<synchronize/>
</commandline>

the Ouput file looks:

Summary Information
===============================================================================
DB1 = noga-db.noga_Currentversion
DB2 = noga-db.Noga_Unitest_II

Object type Name Records DB1 DB2

---

Table [dbo].[tbl_Bank] 3 <> <>
Table [dbo].[tbl_BRStatus] 1 <> <>
Table [dbo].[tbl_BRTavlatHachlataLeShemPeula] 70 <> <>
Table [dbo].[tbl_C...onSeferRashiLeDochLaOtzar] 156 >>
Table [dbo].[tbl_MigzarBeKupaChitzonit] 75 >>
Table [dbo].[tbl_MigzarBeKupaChitzonit] 6 <<
Table [dbo].[tbl_MigzarKupa] 269 >>
Table [dbo].[tbl_MigzarKupa] 69 <<
Table [dbo].[tbl_MigzarLeMaslulBeHeskemDanach] 3 <> <>
Table [dbo].[tbl_MigzarLeMaslulBeHeskemDanach] 115 <<
Table [dbo].[tbl_MosadotBeMasav] 3810 >>
Table [dbo].[tbl_ParameterLeDochLaOtzar] 24 >>
Table [dbo].[tbl_SugeyPeulaBeBachan] 39 >>
Table [dbo].[tbl_SYBatchInterfaceDef] 6 <> <>
Table [dbo].[tbl_SYBatchProcessParameterDef] 7 >>
Table [dbo].[TBL_SYReportColumnDef] 667 <> <>
Table [dbo].[tbl_SYReportGeneratorDef] 1 <> <>
Table [dbo].[tbl_TedirutLeChodesh] 17 >>

---

Error: Database error executing migration script: DELETE statement conflicted
with COLUMN REFERENCE constraint 'FK_SeifHafkadaLeMigzarKupa_MigzarKupaID'. The
conflict occurred in database 'Noga_Unitest_II', table
'tbl_SeifHafkadaLeMigzarKupa', column 'MigzarKupaID'.

It is quiet strange since some of tables in the output file do not exis in the XML argfile, more when I try to compare with sqlDaacompare program the tables which are in the XML argfile all tables are Identical.
DO I miss anything
Thanks
Sandu

Brian Donahue

Hello Sandu,

You probably want to disable foreign keys during tghe synchronization to help prevent the error from occurring. To get SQLDataCompare to do this, add

<options>k</options>

I've also noticed that when you use the /ignoreidentical switch, the tables aren't shown in the report if they do not have missing/additional or different records.

sandu

Hello Brian,
Thanks I will try it .
Actually now in a seconed look I see my problem , there were few tables that I didn't want to compare but they equal in 10 first letter with one tha I do want .I should have exclude them.
Sorry
and thanks again
Sandu