VistaDB 5
Gibraltar VistaDB > Developer's Guide > How To Perform Common Tasks > How To - Migrate from VistaDB to SQL Server
How To - Migrate from VistaDB to SQL Server

Writing Your Own Migration

The best approach if you intend to perform multiple migrations from VistaDB to SQL Server is to build a feature into your application to copy the data up.  Under this approach you would:

  1. Create the schema in SQL Server: See Data Builder - Generate Schema Deployment Script for an easy way to create a single TSQL script that works with VistadB and SQL Server.
  2. Execute your custom database copy routine: If you can't copy your tables in foreign key order to ensure all foreign keys are satisfied then defer adding foreign keys from step 1 to step 3.
  3. Finalize the schema: If any foreign keys were deferred from step #1 then add them now that all data has been migrated.

As a model for the database copy routine we suggest looking at ADO.NET Generic Copy Table Data Function

SQL Server Integration Services

VistaDB doesn't have a build-in tool or utility to upsize your data to SQL Server.  SQL Server 2008 includes the ability to import from an ADO.NET Provider which is sufficient for many use cases.  The VistaDB.5.NET40.dll assembly will have to be available on the client and the SQL Server where SSIS runs.

See Also