xSQL Data Compare new build

New build of xSQL Data Compare that fixes an issue with the sync script serialization is available for download. Under certain conditions the serialization of the synchronization script would fail – while that failure is mostly transparent to the end user as the process will continue normally, it would be exposed in cases when the synchronization script is very large.

xSQL Data Compare provides for comparing and synchronizing data in two SQL Server databases. The current version supports SQL Server 2008/2005/2000 - all editions. xSQL Data Compare is free for SQL Server Express with no restrictions. For other editions of SQL Server it is only free if the number of objects does not exceed certain limits listed here: http://www.xsql.com/LiteEdition.aspx. You can download your free copy from here: http://www.xsql.com/download/sql_server_data_compare/

Script Executor for DB2 free today

Today only you can get a free license for Script Executor for DB2 - use discount code TWITDB2EX when placing the order. Script Executor is one of the best tools for deploying t-sql scripts to your database server "farm". Whether you are running DB2, SQL Server, MySQL or a combination of those platforms, Script Executor allows you to easily create deployment packages involving hundreds of scripts that have to be executed in a certain order targeting as many servers as you need on any of those platforms, simultaneously.

Download a free, fully functional trial version and see for yourself what you have been missing until now:  http://www.xsql.com/download/script_executor/ 

Profiler for SQL Express

The lack of profiling tools for SQL Server Express has been one of the issues small developers have had to grapple with. If you are one of those developers check out xSQL Profiler – it provides all the functionality of the SQL Profiler and more. It supports all editions of SQL Server including MSDE and SQL Express. What’s more the xSQL Profiler is free for two SQL Server instances – fully functional, no strings attached.

So, if you are looking for a profiler for SQL Express you can get it here for free.

xSQL Documenter V4 released

One of the best database documenting tools in the market just got better - we released xSQL Documenter V4 with the following new and enhanced features:

• support for Microsoft Integration Server 2005/2008, Teradata 13 and SQLite;
• enhanced Extended Property Editor to support more platforms and support for comments on procedure parameters;
• A new “columns” section for table valued functions shows what columns they return (SQL Server only);
• Deterministic, schema bound and inline properties for functions were added (SQL Server only);
• Ability to suppress object dependencies on schemas (SQL Server only);
• Ability to specify max number of threads in GUI (the equivalent of the command line switch /threads);
• Support for replacing tabs with spaces in DDL;
• Scripting of users, logins, and roles for SQL Server;
• Support for connecting to Oracle using ODBC;
• More details in the foreign keys section for SQL Server;
• Specify sample rows from tables separately from sample rows for views since views can be very "expensive";
• Ability to order sample rows;

Database management systems that were already supported in the previous version are:

• Microsoft SQL Server 2000/2005/2008
• Microsoft Analysis Server 2005/2008
• Microsoft Report Server 2005/2008
• Oracle 9i and above
• DB2 8.2 and above
• MySQL 5.0 and above
• Sybase ASE 12.0 and above
• Sybase SQL Anywhere 10.0 and up
• Informix IDS 10.0 and above
• PostgreSQL 8.0 and above
• Microsoft Access 97 and above
• VistaDB 3.0 and above
• ENEA Polyhedra 7.0 and above
• Raima RDM Server 8.1

Download a free, non-expiring trial version from http://www.xsql.com/download/database_documenter/ and let us know what you think.

xSQL Builder new build available

Just published a new build of xSQL Builder with improved handling of backup files when the user chooses the "Create destination database from a backup" option. The new build also comes with a new and improved install mechanism.

Targeting primarily software publishers, xSQL Builder is one of the best SQL Server database deployment tools. In just minutes you can create an executable package that embeds wither the schema of the master database only or a complete backup of the master database. When you run the executable on the client depending on the configuration it will either create and restore the database from scratch or compare the existing database with the embedded schema and update the target with the changes. Of course software publishers are not the only ones who would benefit from using xSQL Builder - anyone in need of deploying a SQL Server database will find xSQL Builder to be an indispensable tool.

You can download the new build from: http://www.xsql.com/download/sql_database_deployment_builder/

Best way to create an rss feed from SQL Server

If you are looking for a quick and easy way to create and maintain dynamic rss feeds from SQL Server then RSS Reporter is your best bet. Completely free for one SQL Server instance RSS Reporter for SQL Server supports SQL Server 2008, 2005 and 2000. It allows you to write a t-sql query and automatically generates an rss feed with the results of the query. Every time a feed reader refreshes the feed the query you have defined will be executed against the chosen database and the feed will be updated with the new results.

Need to change the rss feed? No problem – simply login to the rss reporter admin interface, modify the query, save it and you are done – all users that are reading that feed will get the new results next time the feed is refreshed.

Best of all: RSS Reporter for SQL Server is completely free (no strings attached) for a single SQL Server instance and only $99 for 5 SQL Server instances. A DBA in charge of monitoring SQL jobs from multiple servers will greatly appreciate the pre-built SQL Server jobs feeds – all jobs from all servers in one aggregate rss feed; that is efficiency!