New Database Wizard In WebScheduler 3

Stepping-up to version 3, WebScheduler introduces “WebScheduler Database Wizard”, an automatic tool for WebScheduler’s database creation. Forget all the hassles of creating each table and field, you can now create a new WebScheduler database with standard fields with a flick of finger. By simply specifying the SQL Server name and the database name, WebScheduler database wizard automatically generates the database. Next is to bind it to a WebScheduler instance in Visual Studio.

To get started, right click on a WebScheduler instance and select “WebScheduler Database Wizard” option to use this embedded tool.

Follow the onscreen instruction below to quickly create your new WebScheduler SQL database.

Database name drop down list
When the connection to the designated SQL Server has been successfully established, simply specify a new database by typing the name on the textbox. Alternatively, you can select one of the existing databases from the drop down list. Press “Create” and all required tables for WebScheduler with standard fields will be created automatically.

“Get SQL Script” button.
The database wizard also provides a more advanced option to generate the SQL script for the tables definition. The SQL script is primarily useful if you would like to customize the fields definition or add more fields to the table. Simply click on the Get SQL Script button to obtain the complete SQL statements and easily apply it in your own database, for example a Microsoft Access database.

The following screenshot shows the result of T-SQL compatible script.

Note that there are 2 options for the script definition; “MS SQL Compatible” and “MS Access Compatible”. You can choose the one that suit your preferred database provider.

That’s all for now. if you have any questions or feedback. Please share with us in our forum.

Warm Regards,
Budianto Muliawan.

About these ads

2 thoughts on “New Database Wizard In WebScheduler 3

  1. AJ

    For developers using MySQL as their database — can Intersoft create a text file of the sql statements to create the necessary tables?

    Reply
    1. Budianto

      Unfortunately, using current version of the database wizard in MySQL, a little adjustment is needed since there are some sql statements that do not compatible with MySQL. As far as I can tell, Identity(1,1) in SQL should be changed to AUTO_INCREMENT in MySQL.

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s