Skip to content

MVsync

MVsync keeps a SQL Server database synchronized with the files in your MultiValue database, and presents the multivalued data as normalized SQL views.

MVsync provides the tools required to dynamically maintain a SQL Server database of multi valued data files with data from files in a multi value database. MultiValue database environments supported include UniVerse, UniData, OpenQM, jBase and D3. In addition to synchronizing between a MultiValue database and SQL Server, updates to a SQL Server may also be replicated in the MultiValue database.

Additionally, in order to present the rich multi valued data structures in the first normal form, your multi valued data needs to be normalized. This entails expanding out associated multi valued data into separate tables that can be joined together to represent your data in the first normal form.

This is done dynamically when data is accessed, by the Dynamic Normalization engine embedded in your SQL Server database engine. Multiple views are created that can be accessed as normal SQL tables. All data transformation (dates, conversion codes etc.) is managed inside the normalization engine.

A rich set of GUI tools makes creating these views simple, and a data analysis engine scans your data and automatically creates the views based on a set of simple rules. The GUI tools can be used to make any modifications required.

Quick start Install MVsync

Start here

  1. Follow the quick start
    Install MVsync, add your servers, synchronize a file and deploy your first view in the fewest steps.

  2. Install MVsync
    Check the prerequisites, enable MSMQ and install the MVsync Administrator.

  3. Synchronize your data
    Install the synchronization server, choose the files to synchronize and start the server.

  4. Normalize your data
    Analyze your files and deploy normalized views in SQL Server.

Explore the documentation

  • Get started

    A quick start from installation to your first normalized view, plus the full installation steps.

    Quick start · Installation

  • Data synchronization

    Keep SQL Server up to date with your MultiValue files, and replicate SQL Server updates back.

    Data synchronization

  • Data normalization

    Expand multivalued data into views that can be queried as normal SQL tables.

    Data normalization

Works with MVsharp

MVsync requires MVsharp 4.0.8.0 or later. See the MVsharp documentation.