Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Lee Kelleher 4026 posts 15836 karma points MVP 13x admin c-trib
    Jan 16, 2011 @ 22:45
    Lee Kelleher
    0

    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.

  • Aaron Powell 1708 posts 3046 karma points c-trib
    Jan 16, 2011 @ 23:18
    Aaron Powell
    0

    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.

  • Lee Kelleher 4026 posts 15836 karma points MVP 13x admin c-trib
    Jan 16, 2011 @ 23:49
    Lee Kelleher
    0

    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.

  • Aaron Powell 1708 posts 3046 karma points c-trib
    Jan 17, 2011 @ 00:03
    Aaron Powell
    0

    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)

Please Sign in or register to post replies

Write your reply to:

Draft