Moving data from one database to another

Assume I have a MySQL and SQL Server database, each using the schema using the exact same LightSpeed migrations. I'd like to "clone" the data from MySQL to SQL Server as follows:

class Blog : Entity<long>
{
    /* some properties */
}

class Post : Entity<long>
{
    /* some properties */
}

LightspeedContext context1 = CreateMySqlLightSpeedContext("database1");
LightspeedContext context2 = CreateSqlServerLightSpeedContext("database2");

using(var uow1 = context1.CreateUnitOfWork())
{
    using(var uow2 = context1.CreateUnitOfWork())
    {
        uow1.CopyTo(uow2);
    }
}

Does LightSpeed provide the infrastructure to do this without having to explicitly copy each entity by entity? I'd like to preserve dates, primary keys and so forth.

Werner

Not at such a broad level but you can use UnitOfWork.Import combined with UnitOfWork.Attach to handle this, e.g.

using(var uow1 = context1.CreateUnitOfWork())
{
    using(var uow2 = context1.CreateUnitOfWork())
    {
        foreach (var entity in uow1.MyEntities.ToList())
        {
          uow2.Attach(uow2.Import(entity));
        }

        uow2.SaveChanges();
    }
}

Jeremy