xSQL Builder 2.0.0.0
Updated on 07 Aug 2011
By Anthony Buckner
By Anthony Buckner
1.5 MB Safe To Install
Advertising
Specifications
License:
Time-limited trial (Free to try)
Updated:
Downloads:
154
Platform:
Windows 2K / XP / 2003 / Vista
Publisher:
xSQL Software(more)
Website:
Unknown
User Reviews:
Other versions:
Do you like
xSQL Builder?
xSQL Builder?
Publisher's Descriptions
xSQL Builder is a SQL tool that allows for automating the deployment of SQL Server based solutions. xSQL Builder will generate executable packages that contain all the information and logic that is required in order to deploy the database to the clients’ environments, regardless if it's a first time deployment or an upgrade.
The generated, database deployment package can be incorporated into a setup and deployment solution or it can be shipped to clients as a separate application. xSQL Builder is an ideal tool for all software publishers who have deployed (or plan to) SQL Server based solutions to their clients.
Often those clients are running different versions of the application and to make things more complicated in many cases some database customization work may have been performed for certain clients.
In this scenario, deploying a new version of the application that involves structural (schema) changes on the database can be a nightmare – first the change scripts must account for the fact that clients have different versions of the database and second, the custom changes on each client's database must be preserved.
Furthermore, the clients don't usually have the necessary SQL Server expertise to safely deploy the database changes on their environment and the vendor, more often than not, does not have access to the client's environment so it is not possible to handle the upgrade from a central location.
That is exactly what xSQL Builder has been designed to handle – the executable that is shipped to the client determines on the fly what changes need to be applied to each client's database by comparing it to a "master" database that is embedded in the package and the automatically applies those changes.
There is a wide variety of scenarios that are challenging and time consuming to handle utilizing traditional database comparison and synchronization tools and for which xSQL Builder would be an ideal solution.
Following are just some of those scenarios that software developers and publishers face:
· synchronizing multiple client databases with one master database;
· no access to client databases that must be upgraded;
· master database is not reachable from the client machines;
· various clients may be using different version of the application and database (different database schemas);
· need to run custom T-SQL scripts before and/or after synchronizing the client's database to the master database;
· need to generate ready-to-deploy executable packages for all your client databases automatically;
· wish to generate a package for your .NET deployment solution or other setup and deployment utilities;
· need to customize the deployment package before generating;
· must be notified via email when the database deployment package fails to complete all the tasks;
· must log all operations that are performed on the client machine when the package is deployed.
· xSQL Builder has been designed to addresses all these issues by providing a standard interface, simple and yet flexible enough to allow you to fine-tune it to your specific needs.
You can start with xSQL Builder by creating an executable package. The package should be created on the machine that either contains the master database or the master database can be accessed from it. xSQL Builder defines as the "master database" the database the schema of which needs to be propagated down to the clients' environments.
Generating an executable is a simple and straightforward process. xSQL Builder provides a wizard-based interface that guides the user step by step through the process.
The wizard collects the master database schema information, connection settings for the destination database (if available), custom scripts, email notification and few other preferences.
The last step of the wizard invokes the process that generates the executable package and saves it to a folder of your choice.
Along with the executable, a .NET project that contains the source code that runs on the client machine is updated as well. You can open and run the client source code in VS.NET 2005 and fine tune it to address your particular environment.
The executable package generated by xSQL Builder is ready to deploy on the client. It contains, embedded in it, the information required to perform an unattended comparison and synchronization without having to access the master database.
You can choose to run it as it is or you can specify command line options to customize various settings. Upon completion, an email notification is sent to a designated email account of your choice with the execution status.
· .NET Framework 2.0
The generated, database deployment package can be incorporated into a setup and deployment solution or it can be shipped to clients as a separate application. xSQL Builder is an ideal tool for all software publishers who have deployed (or plan to) SQL Server based solutions to their clients.
Often those clients are running different versions of the application and to make things more complicated in many cases some database customization work may have been performed for certain clients.
In this scenario, deploying a new version of the application that involves structural (schema) changes on the database can be a nightmare – first the change scripts must account for the fact that clients have different versions of the database and second, the custom changes on each client's database must be preserved.
Furthermore, the clients don't usually have the necessary SQL Server expertise to safely deploy the database changes on their environment and the vendor, more often than not, does not have access to the client's environment so it is not possible to handle the upgrade from a central location.
That is exactly what xSQL Builder has been designed to handle – the executable that is shipped to the client determines on the fly what changes need to be applied to each client's database by comparing it to a "master" database that is embedded in the package and the automatically applies those changes.
There is a wide variety of scenarios that are challenging and time consuming to handle utilizing traditional database comparison and synchronization tools and for which xSQL Builder would be an ideal solution.
Following are just some of those scenarios that software developers and publishers face:
· synchronizing multiple client databases with one master database;
· no access to client databases that must be upgraded;
· master database is not reachable from the client machines;
· various clients may be using different version of the application and database (different database schemas);
· need to run custom T-SQL scripts before and/or after synchronizing the client's database to the master database;
· need to generate ready-to-deploy executable packages for all your client databases automatically;
· wish to generate a package for your .NET deployment solution or other setup and deployment utilities;
· need to customize the deployment package before generating;
· must be notified via email when the database deployment package fails to complete all the tasks;
· must log all operations that are performed on the client machine when the package is deployed.
· xSQL Builder has been designed to addresses all these issues by providing a standard interface, simple and yet flexible enough to allow you to fine-tune it to your specific needs.
You can start with xSQL Builder by creating an executable package. The package should be created on the machine that either contains the master database or the master database can be accessed from it. xSQL Builder defines as the "master database" the database the schema of which needs to be propagated down to the clients' environments.
Generating an executable is a simple and straightforward process. xSQL Builder provides a wizard-based interface that guides the user step by step through the process.
The wizard collects the master database schema information, connection settings for the destination database (if available), custom scripts, email notification and few other preferences.
The last step of the wizard invokes the process that generates the executable package and saves it to a folder of your choice.
Along with the executable, a .NET project that contains the source code that runs on the client machine is updated as well. You can open and run the client source code in VS.NET 2005 and fine tune it to address your particular environment.
The executable package generated by xSQL Builder is ready to deploy on the client. It contains, embedded in it, the information required to perform an unattended comparison and synchronization without having to access the master database.
You can choose to run it as it is or you can specify command line options to customize various settings. Upon completion, an email notification is sent to a designated email account of your choice with the execution status.
System Requirements
· .NET Framework 2.0
Do you like xSQL Builder
xSQL Builder Disclamer
Please be aware FindMySoft.com accepts no responsibility for the file you are downloading. The same applies to the information provided about the software products listed.
We do not allow the inclusion of any xSQL Builder serial, keygen or crack and we disclaim any liability for the inappropriate use of xSQL Builder.
FindMySoft advises that xSQL Builder should be only used in accordance with the rules of intellectual property and the existing Criminal Code.
For your own protection ALWAYS check downloaded files for viruses.
We do not allow the inclusion of any xSQL Builder serial, keygen or crack and we disclaim any liability for the inappropriate use of xSQL Builder.
FindMySoft advises that xSQL Builder should be only used in accordance with the rules of intellectual property and the existing Criminal Code.
For your own protection ALWAYS check downloaded files for viruses.
Advertising
Popular News
As of yesterday, March 23, Yahoo! can boast that it has its own web browser: Yahoo! Axis.
A week after the RC, the final edition of Linux Mint 13 codename Maya has been released.
Your Rating
1.0
out
of
5
of
5
Rated By
1 Users
1 Users
Top Downloads
2.
Opera5.
Trillian8.
AIM9.
Skype10.
Ad-Aware12.
Nero13.
Google Earth14.
Picasa15.
Winamp16.
iTunes17.
RealPlayer18.
uTorrent19.
eMule20.
WinRAR21.
BitComet22.
WinZip23.
Shareaza24.
CCleaner25.
Recuva26.
Tweak UI27.
CuteFTP Home29.
Adobe Reader30.
NewsPiperBecome A Fan!
Link To Us!
xSQL Builder
HTML Linking Code
HTML Linking Code
Latest Reviews