New answers tagged transactional-replication
When I need to do something like this, I just use sys.objects. After you restore the NewWarehouseDatabase databse, create a Linked Server on the instance where you have WarehouseDatabase to point to the instance where you have the NewWarehouseDatabase databse. Then write an EXCEPT query using sys.objects. Something like this: select o.name from ...
If I understand you question correctly you could use a schema compare tool to generate a script that would be used to insert the extra SPs and triggers into the new datawarehouse DB. Redgate have a tool like this in their DBA bundle and I think data and schema compare are now functionalities of visual studio.
Correct me if I'm wrong, but this is how I understand the process of copying widgets. Copy widgets from the site servers (A and B) to the Central Server If a widget needs additional processing, copy that widget from the central server to its site server A or B At this point, site A has its own records plus X site B records Transaction replication is ...
If I understand you correctly the data is purged from the publisher database on a weekly basis - correct? In this case I would set up replication to a subscriber and then transfer the data from the subscriber to a data warehouse, as Max Vernon suggested. Hope this helps Yomet
Top 50 recent answers are included