Re: Replicating the schema while preserving existing data

Marc,
something is definitely wrong here. Can you post up the table schema
(Field1|Field2|Field3) and script out the publication and post it up. Also,
please confirm that you are on sp3. I'll try to reproduce, because what
you're seeing shouldn't happen.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)





.

Relevant Pages

  • Re: Bulkload - permissions
    ... What are the permissions of the process running the script? ... that the Sql Server account can see the schema. ...
    (microsoft.public.sqlserver.xml)
  • Re: automate tool to change column type?
    ... schema ahead of time. ... is the change such that you can do it with ALTER TABLE? ... but save and carefully review the script. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Generate sp_addsubscriber
    ... SQL Server masks the output... ... > Add one subscriber, and then script out your publication. ... > generate a new script for this, you have to manually add it. ...
    (microsoft.public.sqlserver.replication)
  • Re: Automatic Publication Creation
    ... sorry also you need to issue the command after the script has run to run the ... -- Start the initial Snapshot job ... I created a first publication and used the ... function "generated sql script to create the publication" of SQL server ...
    (microsoft.public.sqlserver.ce)
  • Re: Merge replication and dynamic filters question
    ... I don't know why you get this error message from EM but the script runs. ... far as the publication I posted up goes you're quite right - I just tested ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
Loading