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
  • 179
  • $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
  • SecureCRT for Linux  v.8.5.1SecureCRT is a rock-solid terminal emulator with the strong encryption and authentication options of the Secure Shell protocol. SecureCRT has advanced session management features, a multi-session tabbed interface, scripting, and numerous emulations.
  • 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 ...