Activity overview
Latest activity by DBADave
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...
Exclusions
Hello.Is there a way when using the command line with a Script source to exclude either an entire subfolder of the Scripts root folder? If I have \Database\Tables\ & \Database\Static Data\, can I e...
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!
High Contrast
As a new user to SQL Compare 5 I'm slightly disapointed to see that the application doesn't abide by the High Contrast Black colour scheme. In the Project Configuration dialog box I can't read any...
Thanks, I thought that might be the case. / comments
Thanks, I thought that might be the case.
Comparing data in joined tables
I'm evaluating SQL Data Compare and was wondering whether it can do the following.
I have a typical parent-child table relationship, the parent table holds financial instrument data, keyed on an id...