Comments
Sort by recent activity
2005 and 2008 was LocalService - and - you guessed it - 2000 was Local System Account.
Thanks! / comments
2005 and 2008 was LocalService - and - you guessed it - 2000 was Local System Account.
Thanks!
Great - Where do I get the latest Beta/preview of SQL Data Compare 8? (It doesn't appear to be released yet).
My previous 8.0 beta download has "trial expired". We use 7.1 for production work ATM. / comments
Great - Where do I get the latest Beta/preview of SQL Data Compare 8? (It doesn't appear to be released yet).
My previous 8.0 beta download has "trial expired". We use 7.1 for production work ATM.
We had 7 different projects for the same product (and database) this year - with a couple being offshore and the rest in-house. Merging code is a challenge, and I could see the ability to merge data from multiple sources as a benefit.
We can work around it by just using the data scripts, and "de-coupling" them, i.e. after modification, we can't use them for comparison. At that point we can create a scratch database if we need further comparisons.
I do like the capability to compare and EXPORT data scripts! / comments
We had 7 different projects for the same product (and database) this year - with a couple being offshore and the rest in-house. Merging code is a challenge, and I could see the ability to merge da...
I guess my point was well hidden in my last message. The data compare against scripts (that could have been modified) could be useful in a project with multiple branches.
An effective code merge requires 3-way compare. This is understandably not an option in SQL Data Compare. We use Araxis Merge which does a very good job of a 3-way compare and merge. We can use it on the SQL scripts to make desired changes, but it wouldn't work too well with the .sdcs files. At that point, we would no longer be able to compare against the "merged" data scripts, and we'd have to either generate another set of data scripts or create another version of the database for further data compares.
The feature is definitely useful as it is implemented (compare and export data scripts, compare against exported data scripts). Allowing compare against a modifed data script would be even *more* powerful. / comments
I guess my point was well hidden in my last message. The data compare against scripts (that could have been modified) could be useful in a project with multiple branches.
An effective code merge r...
Yes. Build 317 reads a previously generated script (generated by Build 306) and allows comparison against SQL Server 2000, 2005 and 2008. / comments
Yes. Build 317 reads a previously generated script (generated by Build 306) and allows comparison against SQL Server 2000, 2005 and 2008.
It happened once - I have not tried to reproduce it.
VS 2005 Team Suite with DBPro
Solution:
2 DB projects
2 DB test projects (VB.Net)
1 class library project (C#) with DBPro custom test
One module in the DB test project has a large .resx file (33,149 lines), including a single test event script of 27,008 lines.
Sequence that led to the NullreferenceException (from memory):
1: Started a Replace All in Entire Solution to replace "somedbname" with "$(somedbname)" in 3-part names (when documenting this several days later, I think it may be possible that I replaced "somedbname." with "$(somedbname)", but I don't really think I did).
2: Replace All would "hang" in one file for several minutes (it may have been the large .resx file, or maybe a stored proc containing 37085 lines, most of which contain database reference, I'm not sure).
3: I cancelled the "hanging" replacement - and that seemed to "hang" also.
4: I repeated the replace, which would now complete and indicate 175 replacements.
5: I then closed VS 2005 (clicked X), and got the error message.
Afterwards, I realized that the setvar variables (which are based on SQLCMD variables) probably won't work in the database test event scripts (since those are not SQLCMD enabled AFAIK).
HTH and Thanks,
Tore. / comments
It happened once - I have not tried to reproduce it.
VS 2005 Team Suite with DBPro
Solution:
2 DB projects
2 DB test projects (VB.Net)
1 class library project (C#) with DBPro custom test
One module...
After initially deleting the files in C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data, The problem first went away for a day or so. But it returned, and I discovered a couple of the files had been compressed, so I decompressed them. I checked the permissions, and my user account has full rights to both the folder and the files. But that didn't seem to help.
I can start SQL Backup, and I can perform backup and restore, but if I leave it up, I get one of these messages for each instance SQL Backup shows (at least that is my suspicion with three error dialogs and three instances. / comments
After initially deleting the files in C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data, The problem first went away for a day or so. But it ret...
I would get this message with a couple of dat files in this folder and lockfile.pid in the parent folder being compressed. Permission were ok, no read-only attributes. I'll see how it goes...
SQL Backup version 5.4.0.55 / comments
I would get this message with a couple of dat files in this folder and lockfile.pid in the parent folder being compressed. Permission were ok, no read-only attributes. I'll see how it goes...
SQL...