I saw some other forum posts about migrating from VistaDB over to SQL Server, but now that Umbraco 4.6 (Juno) has been released with support for SQL CE 4 ... is it possible to migrate the schema/data?
Reason being that I have an old Umbraco 4.0.x install (using VistaDB), which I would love to upgrade to Umbraco 4.6. The web-host didn't have a database-server, so using an embedded database-engine was essential!
VistaDB does have a GUI called Data Builder - but I can't seem to find a download anywhere - it must be a commercial application, but can't find any details about that either!
I haven't tried SQL CE 4 in Management Studio yet - there's probably some data import thing that I can hook in VistaDB.
If anyone else has any suggestions, I'm all ears! :-D
Well if you can import it into SQL Server you could then generate a full script to create a schema and insert data, then run it against the CE4 instance (attach it using VS 2010 SP1)
Migrate from VistaDB to SQL CE 4
I saw some other forum posts about migrating from VistaDB over to SQL Server, but now that Umbraco 4.6 (Juno) has been released with support for SQL CE 4 ... is it possible to migrate the schema/data?
Reason being that I have an old Umbraco 4.0.x install (using VistaDB), which I would love to upgrade to Umbraco 4.6. The web-host didn't have a database-server, so using an embedded database-engine was essential!
Thanks, Lee.
Posts here or posts somewhere else?
VistaDB has to have some kind of a query interface, that's probably you're only option, I doubt anyone has an automated tool for the job.
I mean posts here... plus a "removed" package.
http://our.umbraco.org/forum/core/general/5049-migrate-from-vistadb-to-sql-server
http://our.umbraco.org/forum/ourumb-dev-forum/features/3172-VistaDB-to-SQL-Server-Utility (just noticed this one has a code snippet ... hmmm)
VistaDB does have a GUI called Data Builder - but I can't seem to find a download anywhere - it must be a commercial application, but can't find any details about that either!
I haven't tried SQL CE 4 in Management Studio yet - there's probably some data import thing that I can hook in VistaDB.
If anyone else has any suggestions, I'm all ears! :-D
Cheers, Lee.
Well if you can import it into SQL Server you could then generate a full script to create a schema and insert data, then run it against the CE4 instance (attach it using VS 2010 SP1)
is working on a reply...