Open SQL Server Management Studio,

 1) right click on the database, then Tasks -> Import Data,
 2) select ".NET Framework Data Provider for VistaDB" and follow instractions..

In case you dont find .NET Framework Data Provider for VistaDB in option... you need to download it

in case if you dont want the above aproach.

you can do following.....

 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).


The last option is

http://forums.vistadb.net/yaf_postst3932_Data-Magration-Wizard-Trial.aspx


I hope first one would work. Please mark as answer if you think so.

Thanks

Jigar

(LUV UMBRACO)

i am getting the follwoing error when trying to import from vistaDb to sqlserver2005

The path is not of a legal form.
Error 101 (Provider v. 3.2.1.43): Cannot open data storage or file:  
Error 117 (Provider v. 3.2.1.43): Cannot open database:  
 (VistaDB.NET20)

------------------------------
Program Location:

   at lp.a(String A_0, VistaDBDatabaseOpenMode A_1, String A_2, Boolean A_3, Boolean A_4)
   at lp.b(String A_0, VistaDBDatabaseOpenMode A_1, String A_2)
   at k7.a(String A_0, VistaDBDatabaseOpenMode A_1, String A_2, Boolean A_3)
   at VistaDB.Provider.VistaDBConnection.Open()
   at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
   at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)

===================================

"How to migrate from Vistadb to Sql Server"

This question appears more and more in the forum, which means that some people have the need to migrate - so me too.
Till now i had no success to get the migration done. I did a lot of research using google and friends. Yes there are a few hints about doing it. But all of the approaches (like the one in the 2nd entry of this post) ended up as dead end for me.

So my questions:

1. Did anyone solve the problem and did a migration form vistadb to sql server? And how????
2. Is there a best practice way for doing this?
3. Is/will there be a tool for doing this on an easy way?

Would be glad for any help.

thank you
/horst

HI All,

Has any one tried to load the VistaDB database in Data Builder and do an XML Export of schema and data.

Thanks

Jigar

Hi Jigar,
yes did an xml export. But in SQL Server there's no option for importing xml. At least i didn't recognize one.

And another question i'm asking myself is that there are some "Relationships" in VistaDB and no "Views".
On the other side there are some "Views" in an umbraco SQL Server database.

How can umbraco handle these differences?
So if i achieve to get the VistaDB data imported into SQL Server - does it still work? Are there some more steps to go through?

/horst

is working on a reply...