How can xSQL Data Compare help you?

For the SQL Server DBA: as you are getting ready to call it a day you get a frantic call from the customer service rep telling you that the reps are seeing some weird things on the system, like their case notes all of the sudden have disappeared! After a quick investigation you realize that a bad, bad query (not that this ever happens) one of those triggered updates with no where clause (!) that this rookie developer across the ocean had submitted the day before apparently slipped through the cracks and now the damage has been done. Various scenarios are rushing through your mind – the ultimate goal is to reduce or eliminate the effect of the damage caused while preserving all the other changes that have happened in the database in the meantime as well as minimizing the time during which the database will be unavailable for end users. Determining when the bad query was executed and restoring the database up to that point (right before that transaction) sounds reasonable enough if not much has happened since then but that may not be acceptable if a few hundred (or more) users have generated some thousands of transactions in the meantime. That’s where xSQL Data Compare comes in – you could restore the database up to that point in time on a secondary location without touching the live database – then use xSQL Data Compare to compare the live database with the restored one – you can select to compare just the tables / fields / records that were affected by the bad query. You can then generate scripts to change the values in those particular fields in the given records back to what they were before the mess up happened – all in just a few minutes without having to ever take the database down. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.

For the .NET / SQL Server developer: you have been working for weeks on enhancing a web based system with additional functionality and content. The content resides on SQL server and you have been loading new content on your local server for days now. Now you are ready to publish those enhancements on the live server but there is one catch – the “content manager” guy or gal has been updating content in the live database through the elegant interface you had provided in the last iteration of improvements. So now you have some new or updated content on the production database that does not exist or is outdated on your local database and a few days of new content on your local database that needs to be pushed to the live database. A shot-gun approach where you can take your local database (just the selected tables) and overwrite the live one is not going to work as it will overwrite the changes the “content manager” has made. The only choice you have is to identify all the new content you had loaded in your local database and then repeat the work you did locally on the production database (very painful) OR…you could run xSQL Data Compare that will in seconds identify what’s on the production database that you don’t have locally and vice versa. Even better, with one click you can generate the scripts that will safely transfer the new content from the local database to the production one without affecting the work that the content manager did. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.

For the Data Integrity Auditor: a well designed, mission critical database almost always provides an easy way for you to determine who changed what and when. However, once in a while you may run into situations where certain data changes are not tracked, in other words you can’t see when a certain value was changed and what it was before it was changed. Furthermore, even when you can tell who changed what and when without a way to quickly identify what changed from one day to the other or one state of the database to the other you may be looking for the needle in the haystack – an impossible task. xSQL Data Compare comes to the rescue – you can tell it to compare the data between two versions of the same database while being able to specify the tables, the fields and the records within those tables that are of interest to you. It will quickly display in an intuitive, color coded format, exactly where the changes are between those two versions. Download it now and see the difference – you have two weeks to use it on any size database and you have forever free to use it on smaller size databases.

Click here to download your copy of the fully functional Free Lite Edition now