다음을 통해 공유

Questions and Topics

  • 아티클

If you have any questions in regards to any issue related to SQL / SQL Replication or would like me to post a blog on a topic, please feel free to drop a comment or e-mail me: clsilva@microsoft.com

Comments

  • Anonymous
    January 01, 2003
    HI Mandy, Thank you for posting :) I am a bit confused about your question: When you have set up Transactional Replication, have you used a snapshot to populate the subscriber? Are you using custom SPs for the syncs? If you use the SSMS wizard and set up replication step by step - leaving the default options - do you still get this issue?

  • Anonymous
    July 09, 2009
    I have a question about transaction replication: Can you replicate different schemas between databases i.e. Table1 Gendev.dbo.Test Id            First       Last 1              Mand    Toms 2              Nick       Barfoot Table2 Docraftsv2.dbo.Testname Id            First2     Last2 We would want to populate  testing.table2 with the data from Test.table1 keeping the column names the same.  I have tried this using Stored Procedures [testrep] --SET IDENTITY_INSERT docraftsV2.dbo.test ON insert into docraftsV2.dbo.test (firstname2,lastname2) select firstname,lastname from [Animal].[Gendev].[dbo].[testname] Replication Settings:- Subscription Options:- Whilst this works for the initial snapshot, data is populated and column names remain the same, any further updates etc causes this to fall over, have tried to use the same SP in the Update and Delete delivery formats but no joy. Any assistance would be appreciated Mandy