Activity overview
Latest activity by JohnES
Thank You for your reply. On the data, I'll keep an eye out for things going away that I want to keep. I believe I've proved out that how I have things works, using the UI. But, there's another check I can run to make sure. On the license. I was afraid of something like that, and it's a major part of why I wrote this note. I was hoping I could create a Windows task with a Run As for my special user. Or, worst case, have it run under the account of a user who has the required rights. Either way, it sounds like I really need to spend some time sorting things out. And, how does the RG Data Compare command line app handle the situation where it can't phone home to check the license? I assumed I would need to add a SN parameter or file somewhere. I've been running the RG UI on a server that recently had external internet access suspended. It complains about it but so far it's still worked. John... / comments
Thank You for your reply. On the data, I'll keep an eye out for things going away that I want to keep. I believe I've proved out that how I have things works, using the UI. But, there's another che...
Automating SQL Data Compare Operation.
I'm working on a system to automate the routine synchronization (or partial synchronization) of two MS SQL databases using a project file. I'm pretty sure I can do what I want to, but I worry about...
You're Welcome Jessica. Thank You for your help sorting this out. / comments
You're Welcome Jessica. Thank You for your help sorting this out.
I just encountered this issue again. This time I sent a report, and referenced the title of this thread in the body of the problem description. / comments
I just encountered this issue again. This time I sent a report, and referenced the title of this thread in the body of the problem description.
Index Out of Range, with the latest version?
All of a sudden I started getting an Index Out of Range error when doing a SQL Compare. Does anyone have any idea how I might be able to get past this?I just did an update yesterday, to 13.6.7.8464...
Thank You. / comments
Thank You.
SQL Compare not ignoring trailing comment differences.
I asked about this about 6 months ago and a developer looked into it. He wasn't able to do anything about it at the time but it's still a pretty significant issue for us, so I figured I'd ask about...
I'm guessing that the issue mentioned here is still the case. Redgate might want to update their product pages for SQL Compare to mention this "Pro" version thing and its implications. The only reason I was even looking at this functionality is because the product page talked about it and I figured I'd take a quick look. From what I can see, the only way to get the Pro version is to buy the SQL Toolbelt. But, the price for that is much more than I can reasonably justify for what we use RedGate tools for, so it's not going to happen. / comments
I'm guessing that the issue mentioned here is still the case. Redgate might want to update their product pages for SQL Compare to mention this "Pro" version thing and its implications. The only rea...
I'll give it a try when I get a chance. Thank You. / comments
I'll give it a try when I get a chance. Thank You.
I'm currently having problems with comments and possibly whitespace not being ignored in the diff. Are there any more tricks to try to fix this?
I do have Ignore Comments and Ignore Whitespace checked.
I was running on version 13.0.1.5078, and just updated to 13.2.0.5604, which I believe is the latest (note that the updater code did not work and I had to do it manually).
The code I'm having an issue with looks something like...
Create Table tblSomething --ChangeNum @FromDate, --ChangeNum @ToDate. --ChangeNum
...
The original code does not have the --ChangeNum, but all lines in the right side object do and all lines are being flagged as different. / comments
I'm currently having problems with comments and possibly whitespace not being ignored in the diff. Are there any more tricks to try to fix this?
I do have Ignore Comments and Ignore Whitespace chec...