none
Synchronization between an ERP and Middleware database RRS feed

  • Question

  • 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

    Wednesday, March 28, 2012 3:42 PM

Answers

All replies

  • 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

    Thursday, March 29, 2012 3:36 PM
  • 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 3, 2012 11:22 AM
  • 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 3, 2012 1:01 PM
  • 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 3, 2012 2:14 PM
    Tuesday, April 3, 2012 2:04 PM
  • 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

    Tuesday, April 3, 2012 2:18 PM
  • enabling Sync Framework tracing, that should give you more information on what's happening...

    Thursday, April 5, 2012 10:25 AM
    Moderator
  • June i already have the change tracking enable!!

    Diogo Mota

    Thursday, April 5, 2012 10:46 AM
  • i'm referring to sync framework tracing, not change tracking...
    Thursday, April 5, 2012 10:57 AM
    Moderator
  • sorry, and can you help me with that??

    what do i have to do??

    sorry and thks


    Diogo Mota

    Thursday, April 5, 2012 11:01 AM
    • Marked as answer by Diogo.Mota Thursday, April 26, 2012 11:23 AM
    Thursday, April 5, 2012 11:22 AM
    Moderator