SQL Server Performance

plz suggest suitable replication.

Discussion in 'Performance Tuning for SQL Server Replication' started by santnair, Sep 2, 2005.

  1. santnair New Member

    Hi All,

    I am new to replication.I would like you guys to suggest with reason , which replication to use in this case.

    The System
    -----------
    There is a cetralized database at the home office and there will be temp. offices set up for operation.Each temp office will have a instance of sql server.Each temp offices have to replicate daily transactions.Also while updating the home office, the temp offices should get updated of any changes in home office.

    Should there be any thing kept in mind (Regarding replication), when database is designed.

    Here the connection with home office will very slow may be 12 kbps, dial -up.

    Please advice.
    Thanks in advance.

    --santosh
  2. dineshasanka Moderator

    As you need both ways of updation you need Merge Replication.
  3. santnair New Member

    Thanks.

    Should there be any thing kept in mind (Regarding replication), when database is designed.
    What are the things to be done when designing the database, for replication.

    Regards
  4. ghemant Moderator

    Hi,<br />please refer following articles / tips in this regards :<br /><br /><a href='http://www.sql-server-performance.com/replication_tuning.asp' target='_blank' title='http://www.sql-server-performance.com/replication_tuning.asp'<a target="_blank" href=http://www.sql-server-performance.com/replication_tuning.asp>http://www.sql-server-performance.com/replication_tuning.asp</a></a><br /><br /><a href='http://www.sql-server-performance.com/snapshot_replication_tuning.asp' target='_blank' title='http://www.sql-server-performance.com/snapshot_replication_tuning.asp'<a target="_blank" href=http://www.sql-server-performance.com/snapshot_replication_tuning.asp>http://www.sql-server-performance.com/snapshot_replication_tuning.asp</a></a><br /><br /><a href='http://www.sql-server-performance.com/merge_replication.asp' target='_blank' title='http://www.sql-server-performance.com/merge_replication.asp'<a target="_blank" href=http://www.sql-server-performance.com/merge_replication.asp>http://www.sql-server-performance.com/merge_replication.asp</a></a><br /><br /><a href='http://www.mssqlcity.com/Tips/replication_optimization.htm' target='_blank' title='http://www.mssqlcity.com/Tips/replication_optimization.htm'<a target="_blank" href=http://www.mssqlcity.com/Tips/replication_optimization.htm>http://www.mssqlcity.com/Tips/replication_optimization.htm</a></a><br /><br /><a href='http://www.mssqlcity.com/Articles/Replic/Replic.htm' target='_blank' title='http://www.mssqlcity.com/Articles/Replic/Replic.htm'<a target="_blank" href=http://www.mssqlcity.com/Articles/Replic/Replic.htm>http://www.mssqlcity.com/Articles/Replic/Replic.htm</a></a><br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  5. santnair New Member

    Hi

    Thanks for the replies, those helped a lot in understanding replication.

    Database design for replication is still our concern.Do we have to do anything special related to replication. Here each remote office will be making there own updates.Each table has a Primary key (a identity column). Wont this identity column from diff remote office create conflicts at centralized database.

    I would like to know , what things to be kept in mind when database has to be designed for replication. We are goin to do Merge replication.
    --WE have a centralized office and temprory and mobile remote offices.
    --Network connection is slow.

    I didn't find any thing regarding database design in the above link.

    Thank You

    Regards
  6. dineshasanka Moderator

  7. Akthar New Member

Share This Page