Sql Utilities

The SQL Utilities is a utility found from the Main Menu of VisionCore by selecting the Utilities under File menu.  You may also open the SQL Utilities from the Log In form.

Using this utility enables users to archive Data Files for storage and backup, and retrieving them for future use.

Select an SQL Server:

1.In the SQL Server field, specify the SQL server to which you want to connect. Next to it is the Refresh button. Click this button to display the list of active SQL servers on the network.

2.Select the type of authentication to use when connecting to the server.

If Windows Authentication is selected, you need to be part of a Windows NT domain or workgroup before you can connect to the database server.

If SQL Server Authentication is selected, enter a User Name and Password recognized in SQL Server.

After doing steps 1 and 2, you are now ready to:

Backup a Database

In the Database field, select the database name to be backed-up. Next to it is the Refresh button. Click on this button to show the list of active databases.

In Backup Name and Path field, provide a suitable name and description for the file or select an existing backup to overwrite. Set the destination for the backup and click on the backup database button.

Click on the Backup database button.  The Backup utility would then confirm the success of the operation.

Restore a Database

In the Database field, enter a name for the database to be restored.

In the File to Restore field, click the browse button and select the Backup data file you want to restore.

In the File Path field, click the browse button and select the path for the database to be restored.

Click on the Restore Database button. The Restore utility would then confirm the success of the operation.

Detach a Database

In the Database field, enter or select the existing database name to be detached. Next to it is the Refresh button. Click on this button to show the list of active databases.

Click on the Detach Database button. The Detach utility would then confirm the success of the operation.

Attach a Database

In the Database field, enter a database name to be attached.

Click the Browse button and select the main data file (.mdf) and log data file (.ldf).

Click on the Attach Database button. The Attach utility would then confirm the success of the operation.

Shrink Database

Shrinking a database is reducing the size of a database by collectively shrinking the data files and releasing unused space.

In the Database field, enter or select the database you want to shrink.  Next to is is the Refresh button.  Click on this button to show the list of active databases.

Click on the Shrink Database button.  The Shrink utility will then confirm the success of the operation.

Delete a Database

In the Database field, select the database name to be deleted. Next to it is the Refresh button. Click on this button to show the list of active databases.

Click on the Delete Database button. The delete utility would then confirm the success of the deletion.

Note that this action cannot be undone.  Once you click the Delete Database button, VisionCore will delete the selected database and there will be No way of Retrieving that database again.

Clear Data

This tool will clear transactions and balances from the system.

•Select the Database name where the data will be deleted. Next to it is the Refresh button. Click this button to show the list of active databases.

•In Backup Name and Path field, enter the appropriate database name and set its destination.

•Check an option from the Clear area. As what the label suggests, this will clear the corresponding Data in VisionCore

•Click the Clear button. The Clear Data utility will then confirm the success of the operation.