I have an interesting scenario I am trying to find a solution to.
We currently have the current setup.
ProductionDatabase (publisher) is the publication for transnational replication to the following: WarehouseDatabase (subscriber) NewWarehouseDatabase (subscriber)
My issue is that WarehouseDatabase has had triggers and other SP's added to it. When I build replication for NewWarehouseDatabase I built it from a backup of ProductionDatabase. So NewWarehouseDatabase does not have the triggers or SP's that had been added to WarehouseDatabase.
Doing a SQL Compare generated a list that had a lot more things displayed than I really want to manage.
So I thought I can build replication by backing up WarehouseDatabase and restoring to NewWarehouseDatabase and then enabling replication from ProductionDatabase. Then I thought that will not work as the LSN and other internals that might not sync up for replication to work.
I am wondering if anyone can suggest how I can accomplish this, if you can understand my babbling...