 |
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.
|
|
|
|
| |
| |
|
xSQL Documenter version 3 released
|
|
[more...]
|
|
|
|
|
| |
| |
| |
| |
| WOW! What a great piece of software (xSQL Profiler) you have written. Well done!! All the best from Scotland. |
| - Jim B. |
| Sigdev Ltd., Scotland |
| |
| xSQL Builder provides us with everything we need to automate our database processes. Thanks to this our database update process is now 6 times faster. |
| - Phil H. |
| i2i Innovate to Integrate, UK |
| |
| This (RSS Reporter) is a very good mashup of traditional sql server management and leading-edge information access! |
| - Robert H. |
| U.S. Xpress Enterprises |
| |
| ...It also features the best (and simplest) way to move objects and data via sql script I’ve ever seen. I’m hooked. |
| - Steve F. |
| Creative Plumbing, GA |
| |
| We have tested ... and compared it with 6 other products. We preferred xSQL Data Compare... |
| - Han van der H. |
| RIVM LTR Laboratory, The Netherlands |
| |
|
|