Tuesday, December 9, 2014

SQL Server Compare tools - new build available

New builds of xSQL Schema Compare and xSQL Data Compare are available for download. The new Schema Compare build includes:
  • some improvements in the user interface such as a new ribbon control, improved docking, tabs and UI style;
  • A fix for an issue with the TEXTIMAGE_ON table clause - it now performs additional checks and only includes the clause when it is required by the table script;
  • A fix for a dependency issue between tables and stored procedures that occurred when the compatibility level was set to SQL Server 2005.
The new build of the Data Compare includes:
  • improvements in the user interface such as a new ribbon control, improved docking, tabs and UI style;
  • improved data grid for displaying row differences.
Both compare tools can be downloaded together as one package from our site at: http://www.xsql.com/download/sql_server_comparison_bundle/

If you are interested in acquiring a license you can either purchase a perpetual license from our site at http://www.xsql.com/order/sql_server_comparison_bundle/ or you can purchase a silver subscription that includes 5 tools or the gold subscription that also includes the xSQL Schema Compare SDK.

Wednesday, November 26, 2014

New RSS Reporter for SQL Server released

We just released a completely redesigned, new version of RSS Reporter for SQL Server. New and/or improved features of version 4 of the RSS Reporter for SQL Server include:
  • Atom or RSS feeds: standard, customizable, Atom or RSS feeds that can be consumed from any connected device.
  • SQL Server 2014 support: full support for all editions of SQL Server 2005, SQL Server 2008/R2, SQL Server 2012, and SQL Server 2014.
  • Fully customizable feeds:  all predefined job and database feeds are fully customizable, you can choose which fields to include/exclude from the field by modifying the web.config file.
  • Significantly improved query feeds: ad-hoc query feeds now have title templates, field labels, ability to set a url for a feed item and more.
  • Admin interface: provides a convenient way for the administrators to create or manage RSS Reporter users and the feeds associated with each user.
  • Simplified licensing: per user, unlimited SQL Server instances, unlimited feed readers.
You can download the new version from: http://www.xsql.com/download/rss_reporter/

Monday, October 20, 2014

Give the gift of SQL tools and enter to win an iPad

From now until November 30, 2014 purchase a new license for any of our tools or a new subscription (http://www.xsql.com/order/) and you will get:
  1. a second license/subscription (the same) at no additional cost to give to a friend
  2. a chance to win an iPad during our end of year holiday drawing
You must use the code GGOTTF14 on checkout - plug in the code into the "Discount" textbox on the shopping cart page.
We will send you the second license within 2 business days from the time you purchase the first license.

Wednesday, August 20, 2014

Free Silver Subscription today and tomorrow - treasure hunt

Today and tomorrow only (August 20 and 21 of 2014), you can get a free 6 months Silver Subscription license that includes 4 of our most popular tools, xSQL Schema Compare, xSQL Data Compare, Script Executor and xSQL Builder, normally $249. To get the license you will need to first find the discount code which is composed of the first letter of the third feature (under the "Features" section on the product page) of the following products in order: xSQL Schema Compare, xSQL Schema Compare SDK, xSQL Data Compare, xSQL Script Executor, xSQL Profiler, xSQL Documenter, xSQL Builder, xSQL RSS Reporter - so the code will have 8 letters. Once you find the code then do the following:
  • go to the Purchase / Silver Subscription
  • select the SN6M-1L1U (Single-User, 6-Month license) 
  • on the shopping cart page plug in the discount code that you identified above and click on "Apply Discount" - that will subtract the full $249 from the price
  • proceed with the checkout to obtain your license.
  • One license per customer.
  • Licenses cannot be resold or transferred.
  • Do not publish the code - any licenses obtained by individuals that did not visit each of the 8 product pages above will be invalidated.
  • The deal expires on 11:59 PM EST on August 21, 2014
Post any comments and/or suggestions here please - we will respond as promptly as we can.

Monday, June 23, 2014

xSQL Schema Compare - Entity Filters

In cases when the two SQL Server databases being compared have a large number of objects and you know that a good percentage of those objects are the same on both of those databases it may be beneficial to only compare a subset of the objects.

xSQL Schema Compare provides a very flexible and powerful facility called entity filters that allow you to specify which objects you wish to compare and synchronize based on the object type and the name of the object. An example of an entity filter is shown in the screen shot below:
Entity filters can be accessed from the context menu of the comparison results grid. Once a schema filter is set, it's definition is stored in the comparison session so if you run the same compare again you do not need to redefine the filters.

Wednesday, April 9, 2014

xSQL Builder V5 with support for SQL Server 2014 released

We just released a new version of xSQL Builder with full support for SQL Server 2014. In addition of supporting SQL Server 2014, the new version also adds support for schema filters and filegroup mapping. You can download the xSQL Builder v5 from our site: http://www.xsql.com/download/sql_database_deployment_builder/

xSQL Builder allows SQL Server developers and particularly software publishers to automate the deployment of SQL Server databases to their clients eliminating the need for the client to have any advanced computer knowledge other than simply executing a package.

xSQL Builder supports SQL Server 2014, SQL Server 2012, SQL Server 2008/R2, SQL Server 2005.

Thursday, April 3, 2014

Schema Compare new build - schema filters are back

A new build of xSQL Schema Compare for SQL Server is available for download now. Here is what the new build brings:
  • Adds the new entity filters for schema compare UI and schema compare command line. The entity filters can be accessed from the context menu of the comparison results grid. Filter definitions are stored as part of the comparison session so you only need to set them once.  
  • Fixes an issue with extended properties associated with view columns.
  • Fixes an issue with cyclical dependencies
  • Minor user-interface improvements
xSQL Schema Compare supports all editions of SQL Server from SQL Server 2005 to SQL Server 2014 and it is completely free (no strings attached) for SQL Server Express.
You can download the new build from our site: http://www.xsql.com/download/sql_server_comparison_bundle/