Home Products VistaDB 3.3 Getting Started with VistaDB 3

Getting Started with VistaDB 3

	Truly embedded ADO.NET 2 SQL database for .NET 2+, CF 2 and Mono Less than 1 MB single assembly deployment Cross-platform Windows, Linux and Mac OS X support using the Mono Project Easy migration from SQL Server TSQL Royalty-free distribution

This Getting Started section requires no coding and is designed to provide a quick overview of what VistaDB can do for you without getting too technical. After reading this page, go to Your first VistaDB application to learn how to create an application that uses VistaDB

1. Download and Install VistaDB
2. Migrate Northwind.MDB to .VDB3 format
3. Use Data Builder with Northwind.VDB
4. Working with your data

1. Download and Install VistaDB

To get started, make sure you have the latest version of VistaDB. If you are new to VistaDB, please the Free 30-day Trial. It's fast and easy. Simply enter your valid email address and you will receive an email with download instructions. No files are sent and the download files are all under 10MB. Registered customers can download the latest version of VistaDB from downloads.

After downloading VistaDB 3 (VistaDB*_Trial.EXE) , run it to install. By default, VistaDB will be installed to C:\Program Files\VistaDB 3.x.

2. Migrate an existing database (Northwind.MDB)

To quickly see VistaDB in action, lets migrate an existing database to VistaDB. The Data Migration Wizard (DMW) allows you to migrate data from VistaDB 2.x, SQL Server, MS-Access and SQL Compact Edition (SQL CE) to the VistaDB .VDB3 format. The icon should be available on your desktop, or you can run DMW from C:\Program Files\VistaDB 3.x\Tools\Data Migration\DataMigrationWizard.exe

Steps to migrate Northwind.mdb to Northwind.vdb

1. Run Data Migration Wizard (DMW)
2. From the DMW, click Next until you reach step 4 of 9
3. Browse and open the Northwind.mdb database located here:
4. C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb
   (If you do not have this file, you can download it from our downloads page)
5. Set the Target database to C:\Temp\Northwind.VDB or to some directory that is convenient. Remember which directory you selected!
6. Click Next and press OK on the Database Login form to reach Step 5
7. Click Next to the end of the wizard and the database should be migrated to VistaDB .VDB format in less than 10 seconds
8. On Step 9 of 9, the last screen, click the "View Database" button to open and view the new Northwind.VDB database using VistaDB's Data Builder utility.

3. Use Data Builder with Northwind.VDB

Northwind.VDB in Data Builder

In the previous step, you should have pressed the "View Database" button to open the new Northwind.VDB database and Data Builder should have launched automatically and opened your database. If you did not do this, simply browse to C:\Temp (or to the directory you selected in step 5 above) and double click on the Northwind.VDB file. This will launch Data Builder and open the database.

4. Working with your data

With the Northwind.VDB database file opened, try the following:

Running SQL-99 commands

1. Click on SQL, which is the first treelist item.
2. In the SQL Expression editor box, enter this statement then press F5:
     SELECT * FROM invoices WHERE quantity > 100
3. This will display the result set in the Data Grid tab.
4. Click on the Results tab (beside Data Grid) to see how many rows were returned and how long the SQL statement took to execute.
5. Try the following SQL statement and press F5:
     SELECT * FROM customers INNER JOIN invoices ON
     (customers.customerid = invoices.customerid) WHERE quantity > 100
6. After you see the results of step 4, press F6 (History) to display the history of your SQL statements. This history windows makes working with interactive V-SQL very efficient.

Working with the Schema

1. Click on Invoices in the treelist
2. Right-click on Invoices and select "Restructure Table" from the popup menu. You can also select this option from the main menu (7th button from the left)
3. Click on the Column Details tab to see the attributes of each individual column.