1

I'm looking into using transactional replication in MS SQL Server 2016 to create a reporting database from our production HR system.

I'm wondering if it's possible to create new stored procedures and tables on the reporting database which will not be dropped as part of the replication sync?

1 Answer 1

3

if it's possible to create new stored procedures and tables on the reporting database which will not be dropped as part of the replication sync?

Yes, you can create new stored procedures and tables on the reporting database.

When creating a publication, you choose the tables and other database objects that you want to publish. Objects that are included in the publications get replicated. You are free to add other objects in the subscriber database.

Read this document which details about publication and limitations: Publish Data and Database Objects

1
  • 1
    Thank you for your time. Commented Feb 14, 2020 at 14:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.