Activity overview
Latest activity by sam.blackburn
If you need to inspect backups often, you might want to check out SQL Clone which can restore multi-terabyte databases in just a few seconds. It works by creating an image file (this first step is slow) and then uses filesystem tricks to rapidly restore as many copies of the database as you want. The "restore single object" feature of SQL Backup uses the same underlying technology as SQL Compare and Data Compare, which can basically parse the backup file to infer the database contents. This is about as close to "mounting" a backup file as you can get without involving SQL Server. Its performance mostly depends on the complexity of your schema rather than the data size, so a 100GB backup with only a few tables should parse in just a few seconds, but a smaller database with 1000 tables will take several minutes. There are also a lot of newer SQL Server features that aren't supported by this parsing method, such as encryption and compression. Hope this helps!
/ comments
If you need to inspect backups often, you might want to check out SQL Clone which can restore multi-terabyte databases in just a few seconds. It works by creating an image file (this first step is...
We've done some work in this area recently. We believe this should be fixed in SQL Compare 14.1.5, which you can get by enabling frequent updates from the Help menu. Does this solve your problem? / comments
We've done some work in this area recently. We believe this should be fixed in SQL Compare 14.1.5, which you can get by enabling frequent updates from the Help menu. Does this solve your problem?
This can occasionally happen if you have an old version of one product and a new version of another product both running in SSMS. If you have SQL Prompt or SQL Source Control installed, it may help to upgrade them to the latest version. If this doesn't solve your problem, please contact support@red-gate.com and we'll try to help you get it running. / comments
This can occasionally happen if you have an old version of one product and a new version of another product both running in SSMS. If you have SQL Prompt or SQL Source Control installed, it may hel...
Most of the UI state gets stored in the registry, in HKEY_CURRENT_USER\Software\Red Gate\SQL Compare 14\UI. My best guess is that your last-saved project is broken in some way that might be causing the application to crash on startup. Did you see a dialog allowing you to send a crash report to Redgate? We might be able to narrow down the problem if you included an email address with the crash report. Feel free to contact support@red-gate.com so they can retrieve it. / comments
Most of the UI state gets stored in the registry, in HKEY_CURRENT_USER\Software\Red Gate\SQL Compare 14\UI. My best guess is that your last-saved project is broken in some way that might be causin...
Unfortunately we didn't implement this for fear of overwriting history tables that are often used to record audit trails. It looks like a few people have requested this feature on our Uservoice page - it would be really helpful to us if you could add your opinion. https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/36059785-include-history-tables-together-with-temporal-tabl / comments
Unfortunately we didn't implement this for fear of overwriting history tables that are often used to record audit trails. It looks like a few people have requested this feature on our Uservoice pa...
You can achieve this sort of customization (and a lot more!) with a Python script, which can basically generate arbitrary values for SQL Data Generator to put in your database. / comments
You can achieve this sort of customization (and a lot more!) with a Python script, which can basically generate arbitrary values for SQL Data Generator to put in your database.
The "MS_Description" field isn't actually saved in your project file at all - a tooltip over the save button indicates that SQL Doc adds an extended property to the object in the database: [image] What is probably happening here is a few objects are being dropped and recreated by other people with access to the database, which causes them to lose their extended properties. / comments
The "MS_Description" field isn't actually saved in your project file at all - a tooltip over the save button indicates that SQL Doc adds an extended property to the object in the database:What is p...
SQL Data Compare uses a "comparison key" to define the uniqueness of rows, in order to determine whether to ALTER each row or DELETE it and INSERT a new one. The default comparison key is the clustered index, but you can choose your own by picking one or more columns from the Tables & Views tab. It is possible that you can end up with duplicate values in the comparison key column(s), in which case SQL Data Compare falls back to putting a WHERE clause against every column in the table, instead of just the comparison key. However, this approach fails if your table contains columns of certain types that can't be used in a WHERE clause. Hope this makes sense! We'll also look into clarifying the error message in a future version. / comments
SQL Data Compare uses a "comparison key" to define the uniqueness of rows, in order to determine whether to ALTER each row or DELETE it and INSERT a new one. The default comparison key is the clus...
If you paste the deployment script into SSMS, do you see any red squiggles under the text? I'd expect such syntax errors to be highlighted so you would see which part of the script is invalid. / comments
If you paste the deployment script into SSMS, do you see any red squiggles under the text? I'd expect such syntax errors to be highlighted so you would see which part of the script is invalid.
SQL Compare creates a configuration file in the scripts folder, usually called RedGateDatabaseProperties.xml. You may be able to hand-edit this file to describe the directory structure you need. / comments
SQL Compare creates a configuration file in the scripts folder, usually called RedGateDatabaseProperties.xml. You may be able to hand-edit this file to describe the directory structure you need.