Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Synchronization between an ERP and Middleware database

Answered Synchronization between an ERP and Middleware database

  • Wednesday, March 28, 2012 3:42 PM
     
     
    Sign In to Vote
    0

    Hi guys

    I'm trying to synchronize some tables from one ERP with other tables created on Visual Studio 2010(middleware database)

    but i'm having some troubles. 

    1st. in some tables, when i add one article on the ERP, there's connection with the sql cause i can see the article there, but when i synchronize the article don't appear in the visual studio(middleware database)

    2nd. in some tables i can synchronize the articles, but since i push Synchronize until the article apeear in the VS it takes lake one hour, and it's not a big database, like 5000 rows

    thanks guys

    regards

    Diogo Mota

     

All Replies

  • Thursday, March 29, 2012 3:36 PM
     
     
    Sign In to Vote
    0

    Hi guys

    I'm trying to synchronize some tables from one ERP with other tables created on Visual Studio 2010(middleware database)

    but i'm having some troubles. 

    1st. in some tables, when i add one article on the ERP, there's connection with the sql cause i can see the article there, but when i synchronize the article don't appear in the visual studio(middleware database)

    2nd. in some tables i can synchronize the articles, but since i push Synchronize until the article apeear in the VS it takes lake one hour, and it's not a big database, like 25000 rows

    thanks guys

    regards

    Diogo Mota

    Anyone please:P

    Diogo Mota

     
  • Tuesday, April 03, 2012 11:22 AM
     
     
    Sign In to Vote
    0

    Hi guys

    I'm trying to synchronize some tables from one ERP with other tables created on Visual Studio 2010(middleware database)

    but i'm having some troubles. 

    1st. in some tables, when i add one article on the ERP, there's connection with the sql cause i can see the article there, but when i synchronize the article don't appear in the visual studio(middleware database)

    2nd. in some tables i can synchronize the articles, but since i push Synchronize until the article apeear in the VS it takes lake one hour, and it's not a big database, like 25000 rows

    thanks guys

    regards

    Diogo Mota

    Anyone please:P

    Diogo Mota

    so guys?? noone can give me a little help???thks

    Diogo Mota

     
  • Tuesday, April 03, 2012 1:01 PM
     
     
    Sign In to Vote
    0
    You will need to provide more details, What version of sync are you using, what databases, are you using WCf for communication, code samples.... so on... The more details the better.
     
  • Tuesday, April 03, 2012 2:04 PM
     
     
    Sign In to Vote
    0

    Hi Racing

    thnks for answer me. so i'm using sync framework2.0

    the databases are one sql server and one compact edition(.sdf)

    i'm not using WCF

    and here is the code i use to synchronize them:

        this.Validate();
                this.cLI_UTENTESBindingSource.EndEdit();
                this.tableAdapterManager.UpdateAll(this.medicineOneDataSet);

                cLI_UTENTESDataGridView.EndEdit();

                MedicineOneTesteSyncSyncAgent syncAgentMedOneTeste = new MedicineOneTesteSyncSyncAgent();


                syncAgentMedOneTeste.cLI_UTENTES.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional;

                syncAgentMedOneTeste.Synchronize();

                cLI_UTENTESTableAdapter.Fill(medicineOneDataSet.CLI_UTENTES);

                medicineOneDataSet.Merge(cLI_UTENTESTableAdapter.GetData());

                cLI_UTENTESTableAdapter.Update(medicineOneDataSet);

    where cli_UTENTES is the table

    Diogo Mota



    • Edited by Diogo.Mota Tuesday, April 03, 2012 2:14 PM
    •  
     
  • Tuesday, April 03, 2012 2:18 PM
     
     
    Sign In to Vote
    0

    Hi Racing

    thnks for answer me. so i'm using sync framework2.0

    the databases are one sql server and one compact edition(.sdf)

    i'm not using WCF

    and here is the code i use to synchronize them:

        this.Validate();
                this.cLI_UTENTESBindingSource.EndEdit();
                this.tableAdapterManager.UpdateAll(this.medicineOneDataSet);

                cLI_UTENTESDataGridView.EndEdit();

                MedicineOneTesteSyncSyncAgent syncAgentMedOneTeste = new MedicineOneTesteSyncSyncAgent();


                syncAgentMedOneTeste.cLI_UTENTES.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional;

                syncAgentMedOneTeste.Synchronize();

                cLI_UTENTESTableAdapter.Fill(medicineOneDataSet.CLI_UTENTES);

                medicineOneDataSet.Merge(cLI_UTENTESTableAdapter.GetData());

                cLI_UTENTESTableAdapter.Update(medicineOneDataSet);

    where cli_UTENTES is the table

    Diogo Mota



    for example with this table i can get the result but it takes to long.

    but with other tables i cant even show new and deleted results

    Diogo Mota

     
  • Thursday, April 05, 2012 10:25 AM
    Moderator
     
     
    Sign In to Vote
    0

    enabling Sync Framework tracing, that should give you more information on what's happening...

     
  • Thursday, April 05, 2012 10:46 AM
     
     
    Sign In to Vote
    0
    June i already have the change tracking enable!!

    Diogo Mota

     
  • Thursday, April 05, 2012 10:57 AM
    Moderator
     
     
    Sign In to Vote
    0
    i'm referring to sync framework tracing, not change tracking...
     
  • Thursday, April 05, 2012 11:01 AM
     
     
    Sign In to Vote
    0

    sorry, and can you help me with that??

    what do i have to do??

    sorry and thks

    Diogo Mota

     
  • Thursday, April 05, 2012 11:22 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    see: Tracing the Synchronization Process
    • Marked As Answer by Diogo.Mota Thursday, April 26, 2012 11:23 AM
    •