Data Builder

Data Migration Wizard screen

VistaDB Data Builder 3

Powerful yet easy-to-use application that lets you visually create and manage VistaDB databases. You can create, modify and delete tables, indexes, triggers, constraints, columns, set database encryption, and more.

Interactive SQL

Data Builder also allows you to run interactive TSQL commands directly against your data. Data Builder automatically maintains a selectable history of your SQL statements so that you can re-run or modify previous statements quickly and easily.

Source Code Included

The full source is included with full licensed versions of VistaDB (not included in trial).  We even allow you to modify the application for inclusion with your application as an administration tool for your users or support personnel at no extra charge.

 

Features

  • Easy-to-use visual application to create, edit and delete tables, columns, indexes, constraints, triggers, relationships
  • Set compression on tables and columns
  • Import and export to XML
  • Set column attributes such as Primary Key, Hidden, Allow Null, Encrypted, Read Only, Compressed and Indexed
  • Create and Modify TSQL stored procedures and User Defined Functions (UDFs)
  • Visually re-order columns
  • Run interactive TSQL commands (with estimated execution path information)
  • View and edit data in tables using a familiar grid style layout for quick data editing
  • Define database password and encryption settings
  • Pack a database to reclaim deleted entities disk space
  • Apply indexes, filters and scopes dynamically on data
  • Create Full-Text Search indexes
  • Manually start, commit or rollback database transactions

 

Testimonial

“Take a look at VistaDB, a new, incredibly fast data access engine built from the ground up for .NET. It's inexpensive, royalty free, and about 100 times smaller than MSDE. Hurry up and buy VistaDB before Microsoft buys the company!”

Les Pinter, MVP