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.
Rules:
  • 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/
 

Tuesday, March 18, 2014

SQL Server max memory and number of processors by edition

SQL Server scale limitations, maximum memory and maximum number of processors utilized for each edition and version of SQL Server, from SQL Server 2005 to SQL Server 2014, are presented in this one page, easy to print pdf document:  http://www.xsql.com/content/SQL_Server_Max_Memory_And_Processors_By_Edition.pdf

The information contained in the document has been collected from publicly available sources and is presented as is. If you find any inaccuracies or misrepresentations in the document please contact us.

While you are here, take a few minutes to check out our recently released xSQL Schema Compare and xSQL Data Compare tools - they are the best tools for the job and they are totally free for SQL Server Express, no restrictions, no limitations.

Monday, March 10, 2014

xSQL Compare Bundle V5 with support for SQL Server 2014 released

We just released version 5 of our SQL Server comparison and synchronization tools, xSQL Schema Compare and xSQL Data Compare, with full support for SQL Server 2014. The release notes provide a more detailed description of what's new in this version. Here is a summary:
  • SQL Server 2014 support: full support for SQL Server 2014 including all new and improved SQL Server 2014 objects such as memory-optimized filegroups, memory-optimized tables, hash and range indexes, columnstore indexes, memory-optimized table types, natively-compiled stored procedures, primary and secondary selective xml indexes, Xml index and namespace paths, etc.
  • New comparison options:  in xSQL Schema Compare you can now choose to include/exclude database filegroups and memory-optimized tables from the comparison and synchronization, whereas in xSQL Data Compare you can now choose to include/exclude from the comparison memory-optimized tables and columnstore tables.
  • Filegroup mapping: xSQL Schema Compare version 5 introduces filegroup mappings feature that allows you to easily handle complex database comparison scenarios involving databases with different filegroup structures.
  • Improved workspace: consistent look, feel and functionality in both comparison tools the xSQL Schema Compare and the xSQL Data Compare; new coloring scheme for comparison sessions allowing you to better organize the comparison sessions in the workspace; separate tab for schema snapshots etc.
xSQL Schema Compare V5 supports SQL Server 2014, SQL Server 2012, SQL Server 2008/2008R2, and SQL Server 2005.
 
xSQL Data Compare V5 supports SQL Server 2014, SQL Server 2012, SQL Server 2008/2008R2, SQL Server 2005, and SQL Server 2000.
 
You can download the new version of the comparison tools as one package from: http://www.xsql.com/download/sql_server_comparison_bundle/

Thursday, February 6, 2014

How to script a SQL Server database object using xSQL Schema SDK

Using the xSQL Schema Compare SDK it is very easy to generate the CREATE, DROP and ALTER (when alter is supported) scripts for any database object. The following example shows how to generate the CREATE script for the table Employees from the AdventureWorks database:

using xSQL.Schema.Core;
using xSQL.Schema.SqlServer;
using xSQL.SchemaCompare.SqlServer;

namespace xSQL.Sdk.SchemaCompare.Examples
{
    class Scripting
    {
        /// <summary>

        /// This method reads the schema of the database AdventureWorks and scripts the table Employee.
        /// </summary>
        public static void Script()
        {
            SqlServer server;
            SqlDatabase database;
            SqlTable table;
            ScriptingOptions options;
            try
            {
                //--create the SQL Server object

                server = new SqlServer(@"(local)");

                //--create the database object

                database = server.GetDatabase("AdventureWorks");

                //--attach an event handler to database.SchemaOperation event in order to get progress information during the schema read

                database.SchemaOperation += new EventHandler<SchemaOperationEventArgs>(database_SchemaOperation);

                //--read the database schema

                database.ReadSchema();

                //--create scripting options;

                options = new ScriptingOptions();
                options.CreateScript = true;
                options.DropScript = false;
                options.AlterScript = false;

                //--locate and script the Employee table

                table = database.SqlTables["HumanResources", "Employee"];
                if (table != null)
                    Console.Write(table.GetScript(options));
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }

        private static void database_SchemaOperation(object sender, SchemaOperationEventArgs e)
        {
            //--exclude verbose messages

            if (e.Message.MessageType != OperationMessageTypeEnum.Verbose)
                Console.WriteLine(e.Message.Text);
        }
    }
}