Activity overview
Latest activity by tbostrup
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!
Error 18456 opening backup for restore to SQL Server 2000
I was going to restore a backup to my default instance on (local) (SQL Server 2000), and got the error:
Reading filelist of "{my backup}"
SQL error -2147217843: Communication link failure
SQL erro...
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...
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.
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.
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...
Folder per table?
My personal preference would probably be to use a single folder for the data - it could be a Data subfolder to Tables - as opposed to a folder per table.
I also see two separate features - export a...
Why the dual representation of data?
It seems that the dual representation of the data ("meta-data" .sdcs files) introduces unneccessary restrictions on what a user can do with the scripted data. The insert scripts are quite straight...
Schema Generated from SQL Server 2000 doesn't work
We are about to migrate from SQL Server 2000 to SQL Server 2008, so this won't be an issue for us over time. But it *could* be useful during migration.
After generating the schema from a SQL Serve...
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...