Activity overview
Latest activity by Pete6627
Hey Alex, I've given what you suggest a try but unfortunately, it's failing to exclude the "ZZ_" prefixed tables. Now that I know it's a regular expression I've tried using the following and few other variations but it really doesn't seem to like any of the exclusions I tell it. I'm currently using: "/Exclude:Table:^sys.*|^Z{2}.*" Which is failing to exclude anything. I've even tried adding ^Item.* to the query as well to see if it starts ignoring the "ItemInventoryTestCertMap" table again, but it's like SQL compare is completely ignoring the exclude command because the table always shows. Edit: I just tried one more thing and this appears to have worked: "/Exclude:Table:sys.*|ZZ_.*" For some reason having the ^ in the query is causing SQLCompare to ignore the exclude command. Odd but at least this is working now, Thanks for your help. / comments
Hey Alex,I've given what you suggest a try but unfortunately, it's failing to exclude the "ZZ_" prefixed tables.Now that I know it's a regular expression I've tried using the following and few othe...
Thanks very much Alex, I'll give that a shot and see how it goes then. Appreciate it. / comments
Thanks very much Alex, I'll give that a shot and see how it goes then.Appreciate it.
SQL Compare Command Line Inconsistent (or I've done it wrong)
Hi all, so all I'm trying to accomplish is to sync across any tables that only exist in the source, excluding any that start with "ZZ_" (these are prefixed development only tables) and "Sys" as the...
Can SQL Compare check for the existence of tables even though they don't exist in the source?
So the title might sound a little strange and I'll try to make this as clear as I can.My scenario is that I'm trying to create an upgrade script to take an application up to the next version.We hav...