XSQL Builder v.1.0.1.5

Advertisement
Advertisement

xSQL Builder 1.0.1.5 is designed with the ability to allow for automating the deployment of SQL Server based solutions. It generates executable packages that contain all the information and logic required to deploy the database to the clients environments regardless of whether it is a first time deployment or an upgrade from a previous version.The self-contained database deployment package can be incorporated into a setup and deployment solution or it can be shipped to clients as a separate application. Customizable C# code templates xSQL Builder uses a set of template files to generate the executable package. The template files are C# classes that contain the compare and synchronize code that runs on the client machine. xSQL Builder ships with a VS.NET 2005 C# project that you can run or modify as needed.Major Features:Ready-to-deploy executable " a simple wizard based interface allows the user to make a few choices such as the master database, the deployment scenario, and then generate a self-contained executable that is ready for deployment. When the package is executed on the client, depending on the deployment scenario, it will either create the database on the client environment as a new database or if it exists it will synchronize it with the embedded master database (schema only without touching the data). Finally, it will execute any post synchronization scripts that may have been specified and send a notification to a designated, configurable, email address.Deploy to multiple clients " the same executable package can be deployed to multiple clients. The destination database and credentials for each client can either be set on the xml configuration file included in the deployment package or can be passed as parameters to the executable at run-time.Self-contained package " the user can choose to either embed the master database in the executable or leave it as an external resource - the later may make sense if you expect the master database to change after the executable package has been generated. Depending on the chosen deployment scenario, xSQL Builder will compress and embed a snapshot of the master database schema, or the complete backup of the database, or the T-SQL scripts.Customizable C# code templates " xSQL Builder uses a set of template files to generate the executable package. The template files are C# classes that contain the compare and synchronize code that runs on the client machine. xSQL Builder ships with a VS.NET 2005 C# project that you can run or modify as needed.Custom pre and post-synchronization scripts " xSQL Builder allows the user to specify a single file or a whole folder containing T-SQL Scripts as the script(s) that should be executed before the target database is synchronized to the master. The same way the user can specify a set of scripts that will be executed after the target database has been synchronized to the master.Extensive logging " xSQL Builder maintains a detailed log of all the events and operations performed on the client"s environment during the execution of the deployment package. There are 3 log files that xSQL Builder generates " the operational log, the synchronization log and the error log.Built in notification " xSQL Builder provides the option to notify a designated operator when the package execution status meets a certain criteria. The email notification relies on Microsoft .NET 2.0 framework and requires a SMTP server along with the necessary credentials. In case of failure the notification email will also contain the error log that allows the recipient to determine the cause of failure.Requirements:

xSQL Builder 1.0.1.5 is designed with the ...

database, sql server, sql server database, schema comparison, synchronization, data compare, deploying database, xsql software

 
  • XSQL Builder
  • 1.0.1.5
  • xSQL Software
  • Windows Vista, Windows XP, Windows 2000
  • Trial
  • 1.4 Mb
  • 178
  • $499.00
 
 

Review XSQL Builder

  • captcha
 

Other software of xSQL Software
  • RSS Reporter  v.2.0.1.6RSS Reporter for SQL Server is a simple, yet extremely useful, tool that generates standard RSS feeds containing information regarding SQL Server jobs like the current status of the job, job details, historical status, feeds containing information ...
  • RSS Reporter for SQL Server  v.3.0.0.0RSS Reporter for SQL Server 3.0.0.0 supplies you with an intuitive and efficient tool which can produce standard RSS feeds containing information regarding SQL Server jobs like the current status of the job, job details, historical status. Feeds ...
  • xSQL Data Compare  v.2.5.1.5xSQL Data Compare is a professional SQL tool for comparing and synchronizing SQL Server database contents. It is used for data migration, database copy, replication verification, data auditing, scripting schema and data together etc. Features ...

New Databases & Networks software
  • Excel Add-ins for FreshBooks  v.1.8Devart Excel Add-in for FreshBooks allows you to use powerful Excel capabilities for processing and analysis of data from FreshBooks, editing external data as usual excel spreadsheets and saving data changes back to FreshBooks ...
  • DbForge Documenter for Oracle  v.1.0dbForge Documenter for Oracle is a handy Oracle documentation tool that automatically generates documentation of an entire Oracle database in HTML, PDF, and MARKDOWN file formats.
  • DbForge Compare Bundle for Oracle  v.4.0Oracle Compare Bundle contains two separate tools, dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle to compare, analyze, synchronize Oracle databases.
  • DbForge Data Generator for Oracle  v.2.0Oracle data generator with extensive collection of basic and meaningful generators for various data types, flexible customization options, templates for creating your own generators, that delivers flawless test data generation in a well-designed UI ...
  • XSmessenger  v.2.9.1XSmessenger is an Instant Messenger (IM) Server and Client program.It makes instant messaging and VoIP possible in a fast, secure, and controllable way, both internally on your companys network as externally from the ...
  • XSQL Data Compare  v.2.5.1.5xSQL Data Compare is a professional SQL tool for comparing and synchronizing SQL Server database contents. It is used for data migration, database copy, replication verification, data auditing, scripting schema and data together etc. Features ...