activerecord-sqlserver-adapter icon indicating copy to clipboard operation
activerecord-sqlserver-adapter copied to clipboard

Consider excluding known system views in structure_dump

Open jonahgeorge opened this issue 4 years ago • 0 comments

Issue

When invoking structure_dump on a database which has replication enabled, a number of replication tables and views are created which should not be managed by external tools.

A list of replication related objects can be found here:

  • https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/replication-tables-transact-sql?view=sql-server-ver15
  • https://docs.microsoft.com/en-us/sql/relational-databases/system-views/replication-views-transact-sql?view=sql-server-ver15

Any reservations to creating a denylist in SQLServerDatabaseTasks to prevent some of these from being passed to defncopy?

Taking on known system objects sounds like a larger task, but something that could be worthwhile:

  • https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-tables-transact-sql?view=sql-server-ver15

jonahgeorge avatar Nov 28 '21 04:11 jonahgeorge