Comments
Sort by recent activity
Hello,
I just got this to work with SQL Source Control. You have to modify the DifferenceFilters.xml file in "%userprofile%\AppData\Local\Red Gate\SQL Source Control 3". For some reason this doesn't apply right away (there might be some sort of cache), but if you close and open SSMS it seems to work.
Hope that helps.
Thanks,
Evan / comments
Hello,
I just got this to work with SQL Source Control. You have to modify the DifferenceFilters.xml file in "%userprofile%\AppData\Local\Red Gate\SQL Source Control 3". For some reason this does...
Hi Chad,
Unfortunately there's no easy way to do this, but I just came up with a workaround.
If you create a filter rule for excluding objects starting with '_', then save the filter, that will actually create a filter file located in "%userprofile%\Documents\SQL Compare\Filters". If you open up that file in notepad, you'll see a statement like the following: <Expression>(@NAME LIKE '_%')</Expression>
You can manually modify that to look like this: <Expression>(@NAME LIKE '\_%' ESCAPE '\')</Expression>
Then save the filter file.
Once the filter file is saved, go back into SQL Compare, open up the filter dropdown, and select "open filter from file". Load the file you just modified and it should now filter out all objects starting with '_'.
Hope that helps.
Thanks,
Evan / comments
Hi Chad,
Unfortunately there's no easy way to do this, but I just came up with a workaround.
If you create a filter rule for excluding objects starting with '_', then save the filter, that will act...
Hi Ed,
Thanks for your post.
I'm not sure why those metrics are missing specifically, but there may be some hints in an old log file. Can you look in "C:\ProgramData\Red Gate\Logs" to see if there are any logs in there that match the date range that you're looking for on the analysis tab?
It's possible that "Machine: Processor Time" could have been captured even if the "Disk Avg" time metrics weren't. Those metrics can't be purged separately (unless you did some manual stuff in the SQL Monitor repository), so that doesn't seem like a possible explanation.
We have a ticket open for you (#23217), so if you'd like to respond to the email you got for that with your logs, I'm happy to take a look.
Thanks,
Evan / comments
Hi Ed,
Thanks for your post.
I'm not sure why those metrics are missing specifically, but there may be some hints in an old log file. Can you look in "C:\ProgramData\Red Gate\Logs" to see if there...
Hello,
Thanks for your post.
To be honest, I'm not really sure what's going on. I was thinking it might have to do with your revision numbers being out of sync somehow, but I just tested that and can't seem to reproduce the behavior you mentioned.
We have a ticket open for you (#23072), can we schedule a call through there so I can take a look?
Regards,
Evan / comments
Hello,
Thanks for your post.
To be honest, I'm not really sure what's going on. I was thinking it might have to do with your revision numbers being out of sync somehow, but I just tested that and ...
Hello,
Thanks for your post.
Unfortunately there isn't much flexibility in the folder structure created by SQL Source Control.
That being said, it shouldn't really be much of a headache, either, because all of the management of folders and files is taken care of automatically by the tool.
For example, if you create a blank repository in TFS and link your database to that, SQL Source Control will create its own folder structure, then when you go to commit, it will create .sql files in the appropriate subfolders that represent each of the objects in your database. As you make changes to your database and check them in, SQL Source Control will update the .sql files or create new ones.
Does that answer the question?
We also have a ticket open for you (#23065), so feel free to contact me that way. I'm happy to discuss on the phone.
Thanks,
Evan / comments
Hello,
Thanks for your post.
Unfortunately there isn't much flexibility in the folder structure created by SQL Source Control.
That being said, it shouldn't really be much of a headache, either, be...
Hello,
Thanks for your post.
There's a switch in SQLCI that allows you to use SQL Compare switches.
See this documentation for SQLCI: http://documentation.red-gate.com/displ ... +and+later
Here's a list of options for the SQL Compare command line: https://documentation.red-gate.com/disp ... mmand+line
So the switch to use in SQLCI should look like the following: /additionalCompareArgs="/options:IgnoretSQLt"
Hope that helps!
Regards,
Evan / comments
Hello,
Thanks for your post.
There's a switch in SQLCI that allows you to use SQL Compare switches.
See this documentation for SQLCI: http://documentation.red-gate.com/displ ... +and+later
Here's a...
Hi Adam,
It looks like this is a bug in the comparison engine that got added into SQL Source Control after version 3.6.0.3. If you'd like to downgrade to that version while we get to the bottom of the issue, you can find it here: ftp://support.red-gate.com/patches/sqls ... .6.0.3.exe
Sorry for the inconvenience.
I'll update this thread when I hear more.
Regards,
Evan / comments
Hi Adam,
It looks like this is a bug in the comparison engine that got added into SQL Source Control after version 3.6.0.3. If you'd like to downgrade to that version while we get to the bottom of...
Hi Adam,
I looked into SPA-601 and tried to use the scripts from that bug to reproduce this one, but to no avail.
If you could send in a backup to support@red-gate.com, that'd be great. (We have a ticket open for you -- number 21542 -- that you should have received an auto-email for, so you can just respond there.)
Thanks,
Evan / comments
Hi Adam,
I looked into SPA-601 and tried to use the scripts from that bug to reproduce this one, but to no avail.
If you could send in a backup to support@red-gate.com, that'd be great. (We have a...
Hello,
Sorry you're experiencing problems with SQL Source Control.
I just tried reproducing this behavior with 3.6.6.178 but haven't been able to.
I used the script in your screenshot (minus the fillfactor part) and it seemed to work fine. Do you have any other settings you're using that I can use to reproduce this here?
Thanks,
Evan / comments
Hello,
Sorry you're experiencing problems with SQL Source Control.
I just tried reproducing this behavior with 3.6.6.178 but haven't been able to.
I used the script in your screenshot (minus the fi...
Hello,
Thanks for your post.
Unfortunately the only way for SQL Source Control to keep track of usernames in the shared model (http://documentation.red-gate.com/displ ... ent+models) is a table we create called RG_AllObjects (this is in tempdb by default, but you can create a dedicated database for it like in the article you mentioned.)
(Also, if you need to get a support ticket started quickly in the future, emailing support@red-gate.com creates a ticket immediately, whereas on the forums, a ticket is only created if no one responds in two days.)
Regards,
Evan / comments
Hello,
Thanks for your post.
Unfortunately the only way for SQL Source Control to keep track of usernames in the shared model (http://documentation.red-gate.com/displ ... ent+models) is a table we ...