Home Products VistaDB 3.2 Tools Data Builder

Data Builder Tool

	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

		Data Builder 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. Data Builder also allows you to run interactive SQL-99 commands directly on 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.

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
• Visually re-order columns
• Run interactive V-SQL commands
• View and edit data in tables
• 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 and test (when available)
• Supports embedded engine and connecting to VistaDB Server remotely
• Manually control transactions