Comments
Sort by recent activity
Hi @CraigEddy thank you for your post and sorry to hear you're having issues with this - I just used your exact script to try and replicate the issue on my machine but unfortunately (or fortunately) it all seems to work fine.
The only key difference I noted, however, was the differences in the dbo.Images table where my backups in SourceLocationResourceNames came through as "AdventureWorks_Production_[X].BAK" where X was 20171220, 20171221 and 20171222 for the past 3 days - I notice yours are showing as FIARPE.bak (x2) and FIARPE_20171221.bak, are any of these expected backup files not being generated, are they not in the folder, or could anything be going wrong at the point Clone consumes them? (Which would be why you end up with the same size etc.)
If this isn't the case and something is indeed going wrong with SQL Clone then I would say the best course of action would be to send this all through to support@red-gate.com along with your serial key and the team will do everything they can to help out ASAP! / comments
Hi @CraigEddy thank you for your post and sorry to hear you're having issues with this - I just used your exact script to try and replicate the issue on my machine but unfortunately (or fortunately...
(Also even though I'm using Prompt 8 it should be the same!) / comments
(Also even though I'm using Prompt 8 it should be the same!)
Hi @ata0 thank you for coming back on this - interestingly in the screenshot, it looks as though the directory the file explorer is pointing at is "...\AppData\Local\Red Gate\" even though it says it is in StylesV2.
What happens when you leave the files as they are and using the [...] button navigate to "...\AppData\Local\Red Gate\" and hit "Ok"? Even if the files aren't being found in the explorer they should be picked up! [image] / comments
Hi @ata0 thank you for coming back on this - interestingly in the screenshot, it looks as though the directory the file explorer is pointing at is "...\AppData\Local\Red Gate\" even though it says ...
Hi @ata0 thank you for your post!
The documentation you've posted seems to be just for importing overall Prompt settings, not just formatting styles.
The correct way to grab a Prompt style out of an existing folder in v9 would be to go to SQL Prompt > Edit Formatting Styles in SSMS and use the [...] to select the correct folder with the styles in OR copy and paste the SQL Prompt style file into this same StylesV2 folder.
Let me know if this solves your issue! / comments
Hi @ata0 thank you for your post!
The documentation you've posted seems to be just for importing overall Prompt settings, not just formatting styles.
The correct way to grab a Prompt style out of a...
Hey Sammi, the documentation to support the SQL Backup Restore and to include DBCC CHECKDB can be found here: https://documentation.red-gate.com/sbu7/worked-examples/backup-verification
You can include the verification checks as part of an ad-hoc / scheduled restore - let me know how you get on! / comments
Hey Sammi, the documentation to support the SQL Backup Restore and to include DBCC CHECKDB can be found here: https://documentation.red-gate.com/sbu7/worked-examples/backup-verification
You can inc...
Hey Devon, if you want to update to the latest version of SQL Compare you can download the version from the website (which will default to trial) and just put your serial key in which will get it all up and running and should resolve the issues you're having.
The link to download is here: https://www.red-gate.com/dynamic/products/sql-development/sql-compare/download
Let me know how you get on! / comments
Hey Devon, if you want to update to the latest version of SQL Compare you can download the version from the website (which will default to trial) and just put your serial key in which will get it a...
Thanks @Jason Hannas not a problem! You can actually get to the updater by following the Update dialogue from within the Redgate tools themselves when prompted to upgrade to the newest version - alternatively, if you use the Toolbelt installer from the website as I posted above this will be the latest versions of all of the tools regardless [image]
Let me know how you get on! / comments
Thanks @Jason Hannas not a problem! You can actually get to the updater by following the Update dialogue from within the Redgate tools themselves when prompted to upgrade to the newest version - a...
Hey Jason, the full SQL Toolbelt can be downloaded and the unified installer run just by following the link on the SQL Toolbelt page: https://www.red-gate.com/dynamic/products/sql-development/sql-toolbelt/download just pop your serial key in and it should activate all of the tools.
Alternatively, log in to Red-gate.com with your serial key linked email address and you'll be able to download a copy of the installer there! Thanks! / comments
Hey Jason, the full SQL Toolbelt can be downloaded and the unified installer run just by following the link on the SQL Toolbelt page: https://www.red-gate.com/dynamic/products/sql-development/sql-t...
Thanks, ThomasH - glad to hear you've gotten this sorted, have a great trial of SQL Compare! / comments
Thanks, ThomasH - glad to hear you've gotten this sorted, have a great trial of SQL Compare!
Hi ThomasH, you might have an issue connecting if you're not connected to the internet, is that the case on the machine you're trying to use SQL Compare on? / comments
Hi ThomasH, you might have an issue connecting if you're not connected to the internet, is that the case on the machine you're trying to use SQL Compare on?