Comments
Sort by recent activity
I'll pass this along as something to add to the list. I don't think I've heard this, so I'm not sure this is a common scenario. / comments
I'll pass this along as something to add to the list. I don't think I've heard this, so I'm not sure this is a common scenario.
If I understand this, you want to populate the Equipment.Operator column with data. This data is a reference to another table, correct? Some Operators table?
Then, you want a NULL in this column if Operator.OwnershipType = Subcontracted, otherwise some valid FK. Is that correct? / comments
If I understand this, you want to populate the Equipment.Operator column with data. This data is a reference to another table, correct? Some Operators table?
Then, you want a NULL in this column if...
OK, I got a note from the developers. The Shared mode doesn't use the Get Latest tab, as all changes are assumed to be in the db. This is because all developers see the same db, and all changes are assumed to be those that need to be committed. So the missing objects are seen as deletes that need to be committed.
To resolve this, link as dedicated mode. Then, if you need multiple developers on the restored db, delink and relink as shared. / comments
OK, I got a note from the developers. The Shared mode doesn't use the Get Latest tab, as all changes are assumed to be in the db. This is because all developers see the same db, and all changes are...
OK, I tried this. Backed up a db (_Dev), then restored as a new name (_Prod_Test). Added objects to the original db (_Dev), which is linked to TFS as a shared db. Linked the restored DB (_Prod_Test) to TFS, same folder, as shared, and Get Latest didn't find objects that I confirm exist in Source Code Explorer.
I restarted SSMS, no change.
I de-linked the new db (Prod_Test) from TFS and relinked as a dedicated db. Get Latest then showed all my objects.
I then deleted this db and added a new, empty db (_soctest). Linked to TFS as shared, and again, don't get any objects. I'll report as a bug. / comments
OK, I tried this. Backed up a db (_Dev), then restored as a new name (_Prod_Test). Added objects to the original db (_Dev), which is linked to TFS as a shared db. Linked the restored DB (_Prod_Test...
You are welcome. Dont' forget to switch the radio button. It remembers the last setting. / comments
You are welcome. Dont' forget to switch the radio button. It remembers the last setting.
Are both of these set up as shared database to your VCS? Which VCS do you use? Not sure it matters, but trying to check. / comments
Are both of these set up as shared database to your VCS? Which VCS do you use? Not sure it matters, but trying to check.
The history comes from your VCS. Once you restore from LIVE, I assume that your VCS will be ahead of the dev database, so you'd want to pull changes from the VCS and apply to the restored db.
All history would still be the same in the VCS at this point as applying changes doesn't change anything in the VCS. / comments
The history comes from your VCS. Once you restore from LIVE, I assume that your VCS will be ahead of the dev database, so you'd want to pull changes from the VCS and apply to the restored db.
All h...
This is correct. A known issue that we don't support compressed native backups. We support SQL Backup compressed backups: https://documentation.red-gate.com/display/SDC12/Working+with+backups / comments
This is correct. A known issue that we don't support compressed native backups. We support SQL Backup compressed backups: https://documentation.red-gate.com/display/SDC12/Working+with+backups
The free ReveUnininstaller should help: https://www.revouninstaller.com/revo_uninstaller_free_download.html / comments
The free ReveUnininstaller should help: https://www.revouninstaller.com/revo_uninstaller_free_download.html
I think you have an issue in your SQLCompare command. I see
/sfx:`"F:\ ...
but then I see
txt`""
My guess if you've mismatched your single and double quotes here. You have single double, but then single double again, when I think it should end with double single quote. / comments
I think you have an issue in your SQLCompare command. I see
/sfx:`"F:\ ...
but then I see
txt`""
My guess if you've mismatched your single and double quotes here. You have single double, but then s...