Commerce Server General - Data Migration - MarshalledData column

This is Interesting: Free IT Magazines  
Home > Archive > Commerce Server General > October 2006 > Data Migration - MarshalledData column





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Data Migration - MarshalledData column
Mark

2006-10-04, 7:30 pm

We are upgrading from CS 2000 to CS 2007. We are rebuilding our site from
Scratch. We need to do the data migration of the historical Order data.
Many of the new transaction tables contain a MarshalledData (image data
type) column. Assume that I have a valid reason for *not* using the upgrade
wizard. Is there a documented way for scipting the creation of the
MarshalledData column during a scripted migration?

Thanks in advance.

Mark


Colin Bowern

2006-10-04, 7:30 pm

Hi Mark,

It's been a while since I've looked at CS2000. I believe the marshalled
data column was a binary serialization using the DBStorage COM object. In
CS2007 they use a .NET binary serialization to store marshalled data. You
will likely need to de-serialize the data using DBStorage and then
re-serialize it using .NET on the destination. I don't believe there are
any specific examples documented however so you'll likely need to build a
prototype to see what issues might arise.

Check out the Data Migration section of the CS2007 migration guide for some
information on the particulars of the marshaled_data.

Cheers,
Colin

"Mark" <markfield88@nospam.nospam> wrote in message
news:%23Poj0u75GHA.2120@TK2MSFTNGP03.phx.gbl...
> We are upgrading from CS 2000 to CS 2007. We are rebuilding our site from
> Scratch. We need to do the data migration of the historical Order data.
> Many of the new transaction tables contain a MarshalledData (image data
> type) column. Assume that I have a valid reason for *not* using the
> upgrade wizard. Is there a documented way for scipting the creation of
> the MarshalledData column during a scripted migration?
>
> Thanks in advance.
>
> Mark
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com