Comments
Sort by recent activity
Jessica R said:
Hi @DBADave ! I'm afraid it's not possible to exclude a folder at the moment. Can you please add a feature request for this on our uservoice forum? https://redgate.uservoice.com/forums/141379-sql-compare Just to confirm though, are you mainly looking to exclude static data? You should be able to do this via the /Include:StaticData switch. >>If not, then what's the /exclude:Table syntax to exclude any table starting with a # Just to confirm, do you mean temporary tables in a pre/post deployment scripts?
Yes, it's to ignore scripts with # or ## temp table definition. / comments
Jessica R said:
Hi @DBADave !I'm afraid it's not possible to exclude a folder at the moment. Can you please add a feature request for this on our uservoice forum? https://redgate.uservoice.co...
@David Atkinson - Yes I think the snapshot should succeed as these scripts are manipulating data rather than creating database objects. Would it be fair to say if the static data exclusion is used then these files would get ignored if they were in the StaticData folder? / comments
@David Atkinson - Yes I think the snapshot should succeed as these scripts are manipulating data rather than creating database objects. Would it be fair to say if the static data exclusion is used...
David Atkinson said:
@DBADave - what are you trying to achieve? Are you just needing to deploy schema changes and not static data? If so, can you explain why?
I'm trying to compare my local Git repository with a database. When building the snapshot if there's multiple files in my Scripts folder that contain a reference to the same #temp table then the snapshot creation fails. / comments
David Atkinson said:
@DBADave - what are you trying to achieve? Are you just needing to deploy schema changes and not static data? If so, can you explain why?
I'm trying to compare my local ...
Jessica R said:
Hi @DBADave ! I'm afraid it's not possible to exclude a folder at the moment. Can you please add a feature request for this on our uservoice forum? https://redgate.uservoice.com/forums/141379-sql-compare Just to confirm though, are you mainly looking to exclude static data? You should be able to do this via the /Include:StaticData switch. >>If not, then what's the /exclude:Table syntax to exclude any table starting with a # Just to confirm, do you mean temporary tables in a pre/post deployment scripts?
Yes, it's to ignore scripts with # or ## table names in them. These are sometimes created for data migration purposes and developers often use the same #table names in multiple scripts. / comments
Jessica R said:
Hi @DBADave !I'm afraid it's not possible to exclude a folder at the moment. Can you please add a feature request for this on our uservoice forum? https://redgate.uservoice.co...
Thanks Jonathan, I guess I'll just have to try and memorise each of the checkboxes! / comments
Thanks Jonathan, I guess I'll just have to try and memorise each of the checkboxes!
Thanks, I thought that might be the case. / comments
Thanks, I thought that might be the case.