SQL Server Performance

Couldn't replicate ???

Discussion in 'Performance Tuning for SQL Server Replication' started by nguyennp, Jan 3, 2006.

  1. nguyennp New Member

    Hi,

    I'm new to replication.
    I configured Server named TESTER as publisher & distributer. Create new publication for database named TEST ( type : Transactional ), then Create a new push subcriptions for database TESTREPLICATION ( on the same Server : TESTER). Then I open a table in database TEST to input some data but I couldn't see any tables or data in database TESTREPLICATION ( I chose Continuously, not scheduled).

    Yet, after the lunch, I could see the tables, no data. I tried to choose Start Synchronizing but not helped.

    Please tell me if I configured incorrectly ?

    Thanks,


    Love in vain is better than love no one.
  2. satya Moderator

    You haven't mentioned which type of replication you're configuring.
    Links for your information to configure replication step by step:
    http://www.codeproject.com/database/MergeReplication.asp
    http://www.databasejournal.com/features/mssql/article.php/1438201
    http://www.databasejournal.com/features/mssql/article.php/1468971
    http://www.mssqlcity.com/Articles/Replic/Replic.htm
    http://vyaskn.tripod.com/repl_ans3.htm

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. dineshasanka Moderator

  4. nguyennp New Member

    Hi,
    Thanks for your replies.

    I'm using Transactional Replication.

    I found a lot of errors in the Replication Monitor ( Distribution Agent error).

    Error Message : Insert Error: Column name or number of supplied values does not match table definition.
    Error Details :
    Insert Error: Column name or number of supplied values does not match table definition.
    (Source: SCALA (Data source); Error number: 213)
    ---------------------------------------------------------------------------------------------------------------
    Insert Error: Column name or number of supplied values does not match table definition.
    (Source: SCALA (Data source); Error number: 213)
    ---------------------------------------------------------------------------------------------------------------


    But I couldn't see anywhere mentioned which tables had the error.



    Love in vain is better than love no one.
  5. nguyennp New Member

    I found there're some tables including IDENTITY column. May be this is the problem.
    But how can I remove these tables from replication without re-configuring the replication ( publisher, distributor,... ) ? Thanks,

    Love in vain is better than love no one.

Share This Page