 |
A new build of xSQL Data Compare is available for download
August 18, 2010
|
|
The new build of xSQL Data Compare introduces two small changes that should not affect the majority of the users: - A bug fix for very large Sql Server numeric values that trigger an overflow exception when converted to .NET native type (decimal in this case).
- An enhancement related to the way values of the type hierachyId are handled. The hierarchyId values will be scripted and synchronized even when they are not well constructed.
You can download the new build here...
|
|
xSQL Database Comparison tools version 3.5 with support for SQL Server 2008 R2 released
May 26, 2010
|
|
We have just published version 3.5 of our database comparison tools, xSQL Object and xSQL Data Compare now with support for SQL Server 2008 R2. Following is the complete list of changes- Support for SQL Server 2008 R2
- The passwords for SQL Server connections are now encrypted and stored in the workspace file thus eliminating the need to enter the password each time the xSQL comparison tools are launched
- Fixing the discrepancies between the name in the object definition and the name in the system catalog. This enhancement addresses an issue caused when the sp_rename procedure is used to rename objects with sql definition such as procedures, views, functions and triggers. The procedure sp_rename in these cases changes only the name in the sys catalog, but it does not change the name in the object's definition. This particular problem manifests itself mostly on SQL Server 2000 databases.
- A new schema options named "Include objects with invalid dependencies" replaces the previous option named "Include views with invalid dependencies"; in addition to views this option now affects stored procedures, functions and triggers.
- Trial expiration issue on Windows Vista and Windows 7 with UAC on. The enhancement addresses an issue with early expiration of xSQL Object and xSQL Data Compare trial period on Windows Vista and Windows 7 when the UAC is turned on - it guarantees that both tools will be fully functional with no restriction for the duration of the trial period. After the trial, the products will revert to Lite edition.
- Some enhancements and bug fixing in the command line utilities including a newly added error code that tracks script execution errors.
- A fix to stored procedure multi-line comments.
- An enhancement in the way xSQL Data Compare handles identity columns. Explicit updates of the identity columns are no longer supported and will trigger data warnings.
You can download the new version here...
|
|
New build of xSQL Database Version Control available for download
May 10, 2010
|
|
|
A new build of xSQL Version Control (xSQLVC) for SQL Server is now available for download. The new build simplifies the configuration steps while giving you more choices on how you wish to copy the master development database from the master server to your local machine - in addition of the backup and restore option you can now copy all or part of the database via SQL Scripts. You can read more about xSQLVC here...
|
|
xSQL Database Version Control released
March 15, 2010
|
|
We are happy to announce the release of xSQL Version Control (xSQLVC) for SQL Server.
xSQLVC is the SQL source control utility you have been waiting for - it allows teams of developers to work worry-free on their
local copies of the database while ensuring that all changes that they make are automatically documented and propagated throughout
the development team - your development team synchronized.
xSQL Database Version Control allows users to:
- Get a copy of the master development database onto their machine.
- Auto generate database change scripts that can be checked in to the master.
- Get changes that other developers may have checked in.
- Maintain a complete history of database changes.
- Organize database change scripts into releases.
- Rollback changes if and when necessary.
- View who has done what changes to the database, when and why.
- Focus on development instead of consuming the energy managing database changes.
Supports SQL Server 2008/2005/2000
You can read more about xSQLVC here...
|
|
xSQL Documenter V3 released
January 24, 2010
|
|
We have just released a new version of xSQL Documenter. Version 3.0 adds the following features to the product: - support for Microsoft Report Server 2005/2008;
- support for Raima RDM Server;
- Support for SVG diagrams. Now the diagrams can be rendered in all browsers, such as Firefox, Opera, Safari, and Internet Explorer;
- Option to use short names in the documentation instead of the three part names
- Each table and view column is now added to the CHM index;
- SQL Server only: support for an extended property filter. If you use a filter, only extended properties named in the filter will be fetched.
- Microsoft Analysis Server: support for excluding XMLA and MDX code for objects.
|
|
xSQL Profiler 1.6 released
January 12, 2010
|
|
A new version of xSQL Profiler including new features and improvements is now available for download. This new version includes: - ability to load the trace data directly to the central repository from a network share without having to go through the monitored servers temp db;
- ability to set different polling intervals for each server for a given trace;
- option to set server level traces reducing the number of traces that will need to be started on the monitored server when database level filtering is applied
|
|
Script Executor 3 with support for SQL Server and MySQL released
February 23, 2009
|
|
We are very excited to announce the release of Script Executor 3 with support for SQL Server and MySQL. Script Executor provides for deploying multiple Sql Scripts against multiple target servers/databases.
Script Executor allows the user to:
- Organize target databases into logical database groups.
- Organize Sql Scripts into logical script containers that can be nested similarly to the windows folder structure.
- Map script containers to databases groups indicating that all scripts in the given container should be executed against all databases on that group.
- Tweak the mapping by including /excluding certain scripts and databases from the group mapping.
- Execute all the selected scripts against all the selected databases based ont he mapping with one click.
- Get a comprehensive execution report with details on the execution of each script.
- View the result sets from all queries in one integrated interface.
- Save the deployment package configuration for future use.
- Generate self-contained executable that can be shipped to the end user who can now deploy the scripts to the target databases without any software or database knowledge.
Supports SQL Server 2008/2005/2000 and MySQL 5.0/5.1
You can read more about Script Executor here...
|
|
xSQL Documenter 2.0 released
November 12, 2008
|
|
We are very happy to announce the release of xSQL Documenter 2.0 that adds support for Sybase's SQL Anywhere, support for columns level dependencies and more.
New in this release:- Support for SQL Server 2008
- Support for Sybase SQL Anywhere 10.0 and up
- Adds a “choose objects” page in the GUI where you can specify what object types you want to document.
- Support for all DBMS platforms in the "exclude objects" GUI. Previously this GUI supported only SQL Server.
- Support for arbitrary HTML in database comments – see /pt command line switch.
- Analysis Server: support for XML comments in MDX scripts. This enables documentation of calculated members.
- Support for cross database and cross server dependencies (through linked servers)
- Support for column dependencies (which columns of which table a stored procedure selects or updates.
- SQL Server: support for XML comments on objects that don't have their DDL stored on the server, such as tables. This is implemented with extended properties.
SQL Server: add extended properties filter. Using this you can restrict by name the extended properties that are fetched by xSQL Documenter.
You can read more about xSQL Documenter here...
|
|
Multiple releases - xSQL Tools now support SQL Server 2008
October 6, 2008
|
|
October 6 marks a major release event for xSQL Software tools. A new version with full support for SQL Server 2008 was released for the following tools: - xSQL Object
- xSQL Data Compare
- xSQL SDK
- xSQL Builder
- RSS Reporter
- xSQL Object Search
- xSQL Script Executor
With this new version you can now work with databases from three generations of SQL Server: SQL Server 2000, SQL Server 2005 and SQL Server 2008. Some of the new and enhanced features introduced by this new version of our database comparison and synchronization tools include:- Support for all new or enhanced data types such as geography, geometry, hierarcgyID etc.
- Support for the table level change tracking feature introduced by SQL Server 2008.
- Data compression support for tables, primary key constraints, unique constraints and indexes.
- Support for the enhanced full-text catalogs and indexes.
- Support for Remote Service bindings for Service Broker.
- Improved object dependency handling.
A detailed description of changes and enhancements on this new release can be found here.
|
|
xSQL Profiler 1.5 released
September 17, 2008
|
|
|
We are excited to announce the release of a new version of xSQL Profiler which in addition of significant performance and other improvements on the core it includes custom query templates that allow the user to gain invaluable insight from the trace data that the xSQL Profiler collects. With the click of button you can now see which queries are bogging a particular server down because of CPU consumption, I/O traffic, Reads or Writes. xSQL Profiler Supports SQL Server 2008, SQL Server 2005 and SQL Server 2000 all editions and continues to be free for up to two SQL Server instances. [more...]
|
|
xSQL Profiler released
May 20, 2008
|
|
|
xSQL Profiler is an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. Monitor multiple SQL Servers from one central location - choose SQL Servers and databases you want to monitor, define precise traces to trace exactly what you need, nothing more nothing less, schedule the traces and forget it - xSQL Profiler takes care of the rest. [more...]
|
|
xSQL Documenter released
March 4, 2008
|
|
|
Comprehensive, uniform, and easily navigable database documentation for all your applications. Generates documentation
in HTML and CHM format; supports all major database management systems: SQL Server, Oracle, DB2, MySQL, Informix IDS,
Sybase ASE, PostgreSQL, Access, VistaDB, ENEA Polyhedra; can run as a console application; documentation can be branded;
supports XML comments added to your objects and a lot [more...]
|
|
Free service released: Check Your SQL Server Security
December 6, 2007
|
|
|
CheckSQL.com is free web based service that
performs some basic security checking on an IP address that you provide. It first attempts to open a TCP/IP
connection on the default SQL Server port on the given IP address - if your server is not listening on the
default port and/or, in the case of SQL Server 2005, is installed with a named instance the service will not
be able to establish a connection and therefore the testing will stop; if it is able to establish a TCP/IP
connection it will then check for the SQL Server version you have installed and will let you know if you have
not installed the latest service pack; lastly, it will attempt to log in using a very small set of commonly
used usernames and passwords (ex: sa / password) and if it succeeds it will let you know.
|
|
Free tools released: xSQL Script Executor and xSQL Object Search
September 24, 2007
|
|
xSQL Script Executor is a small, free tool that allows you to run multiple T-SQL scripts at once against a Sql Server database.
You can choose to run a single script file or a group of files identified by a pattern.
You can select different script execution modes, run it interactively via the user interface or in batches via the command line options.
xSQL Object Search is a free tool that provides for locating database objects by checking their names and/or definition against a search criteria.
You can search on one or multiple databases simultaneously, select from various search options, search for all or specific objects types, export the results to output files and more.
|
|
xSQL Bundle receives highest marks and praise from SSWUG
September 14, 2007
|
|
|
We just received word that Stephen Wynkoop, Microsoft SQL Server MVP and SSWUG founder, has
conducted a professional review of our SQL Server database compare and synchronization bundle.
We were naturally excited and worried when we first got it but as we carefully read through it
excitement and joy would best describe the feelings of the team - Stephen had been duly impressed with our products
and had given them the highest rating possible in all aspects of the review, overall score, installation, usage and real-World usefulness.
You can read Stephen's review [here...]
|
|
xSQL Builder 1.0 released
September 1, 2007
|
|
A new tool is now available to the efficiency-minded database administrators and software developers – xSQL Builder for SQL Server.
Built on top of the xSQL Software's robust comparison and synchronization platform it provides for generating self-contained executable packages that can then be deployed as stand-alone applications or as part of a bigger deployment solution.
The source code of the C# classes that contain the compare and synchronize code that will run on the client machine is included with the package thus providing for the un-restricted customization possibilities.
[more...]
|
|
New RSS Reporter for SQL Server V2.0 released
July 16, 2007
|
|
Now with support for ad-hoc query feeds as well as database size and space allocation feeds.
New in this release
Ad-hoc query feeds – you can generate RSS feeds containing the output of a T-SQL query. Write the query, choose the field(s) you want to use as the feed item title, number of fields you want to display across a row and click save – the feed is automatically generated for you and is ready for consumption. Database info feeds – you can now conveniently monitor database size and space usage through a simple RSS feeds delivered right to your device of choice.
[more...]
|
|
RSS Reporter for SQL Server released
June 18, 2007
|
|
|
We are very excited to announce the release of an innovative new tool for SQL Server database administrators, the RSS Reporter.
No more cluttering your mailbox with hundreds of SQL Server notifications, no more digging through those emails to get the information you need, no more missed important notifications… You can now, in minutes, generate standard RSS feeds that contain all the information you need for monitoring SQL Server jobs running on multiple servers. You can then subscribe to those feeds and read them from any connected device - clean, simple, and standard.
[more...]
|
|
New version 2.5 with command line utilities
April 16, 2007
|
|
|
We are happy to announce the release of version 2.5 of our xSQL Bundle which now includes a Command Line utility for scheduled, unattended SQL Server database schema and data comparison and synchronizations.
New in this release
xSQL Object Command Line utility, easily configurable via the xSQL Object interface, that allows you to schedule database schema comparison and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc. xSQL Data Compare Command Line utility, easily configurable via the xSQL Object interface, that allows you to schedule database schema comparison and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc. Comparison wizards for quick comparisons and synchronizations in both xSQL Object and xSQL Data Compare. Comparison session that allows you to save all the selections you have made during a comparison like the types of objects to be included in the comparison, comparison options you have selected etc. Once saved you can load the session at any time and perform the exact same comparison without having to go through the comparison configuration steps again. Object counts that are now displayed next to each object type in the left panel object tree provide a quick "view" of the size of the database. You can now launch Query Analyzer or SSMS right from the xSQL Object's and xSQL Data Compare's synchronization script window with one click.
Enhanced and improved
To better accommodate the large number of SQL 2005 object types, the object tree on the left panel of the workspace has been organized in groups similar to the way they are organized in SSMS. Navigation through schema snapshots to find what you are looking for is a lot easier - before adding the snapshot to the workspace you can now see the date when the snapshot was taken, the database, the server and the SQL Server version. Database scripting functionality has been completely revamped to better handle very large scripts - it runs in asynchronous mode, the memory usage is capped and it provides progress information while executing. Scripting of Xml Schema Collection object has been improved to display as a properly formatted Xml file. The scripts can now be saved in one of the following encoding types: ANSI (default), ASCII, Unicode, UTF7 and UTF8. You can easily change the encoding type by modifying the value for the scriptFileEncoding key in the xSQLObject.exe.config file Support for bulk insert scripts has been enhanced to allow the user to define custom field and row terminators to ensure that the bulk insert will not fail even when the data in a field contains the terminators commonly used for such purpose. File group "translation" allows for synchronization of databases with different file group structures. For each object type the number of objects found equal, different, only on the left or only on the right is now displayed next to each object type header in the comparison results grid. From the comparison results window you can quickly create a Command Line configuration file. The side to side object script panels on the lower section of the comparison results window can now scroll together or independently - you can "link" or "un-link" the panels from the right-click (context) menu. Comparison results Print/Preview functionality has been improved significantly with the introduction of a table of content that provides a summary of the comparison results, object filtering etc. Schema filters are easier to set now through a much more intuitive interface. xSQL Data Compare comes with a few new options like "regional settings", "bulk file configuration" etc. A separate where clause can now be defined for each table on a pair. Execution of data synchronization script has been enhanced to better handle very large scripts, provide progress information and allow the user to safely cancel the execution at any time during the process.
|
|