Comments
Sort by recent activity
I don't see an easy way to do this. I know we could write a Python script that would read the table and optionally return a NULL, but that's an overly complex approach.
What I'd do is:
call SQL Data Generator from the command line, use a normal FK generator
call a SQL script that looks at Equipment.Ownership and sets Equipment.Operator to null
Really this is likely a quicker approach. I wish SDG included some pre/post processing, but that's not likely to come soon. Instead, I'd set this as a known process for provisioning data sets. Call SDG, then call
update equipment
set operator = null
where ownershiptype = 'Subcontracted' / comments
I don't see an easy way to do this. I know we could write a Python script that would read the table and optionally return a NULL, but that's an overly complex approach.
What I'd do is:
call SQL D...
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