Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem?
+1
A:
If there's an ODBC provider for VistaDB, you could use data transfer services in SQL Server 2000, or (I think) SQL Server Integration Services in SQL Server 2005 to accomplish this.
Neil Barnwell
2009-02-21 11:53:42
Since VistaDB is fully ADO.NET 2 compliant, SSIS would be a good tool for data migration, if switching to SQL Server 2005 onwards
Russ Cam
2009-02-21 12:03:30
FYI - VistaDB is 100% managed code only - no ODBC. ADO.NET 2 Provider Factories that you can load in Management Studio as well.
Jason Short
2009-05-16 06:02:04
+2
A:
Open SQL Server Management Studio, right click on the database, then Tasks -> Import Data, select ".NET Framework Data Provider for VistaDB" and follow instractions..
Koistya Navin
2009-03-25 18:35:34
+1
A:
You can also load the VistaDB database in Data Builder and do an XML Export of schema and data.
That will usually get everything you need out - and it is in a format that SQL Server can import already.
The advantage of having your data in XML is that you could also go to any other database that knows how to load SQL Schema through XML (a lot do these days).
Oh and if your blog is Graffiti they included a tool to let you migrate from VistaDB to Access or SQL Server (only works on their database though).
I also did a blog post on migrating VistaDB to SQL Server using SQL Server Integration Services.
SQL Server import and export wizard doesn't work very well, but I did a blog on using it to migrate as well.
Jason Short
2009-05-16 06:01:18