Replication of the schema of a SQL database

Hi all,

I am doing a replication of a SQL Server 2005 database from one server to another server, everything worked fine. Now, when I added some fields to this database, the replication stopped. can I do replication of a schema of a SQL database? how? Should the replication work even if I add some fields.

What is the error message? Are the tables that got modified being replicated?

|||

The modified tables are not being replicated.

I need to know if I can replicate schemas when I have SQL Server 2005 database, if yes, how?

|||

please provide us more information.. were they being replicated initially? what was the change you made? what is the error message if any? I have no idea when you simply say "The modified tables are not being replicated"...

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?