Page 1 of 1

Transferring databases between different versions

PostPosted: Thu Apr 10, 2003 1:24 pm
by jessi
Hello all,

I'm looking for an elegant solution to the following problem:

A ShopSite user I'm responsible for helping is transitioning from ShopSite
4.x to ShopSite 6. To do so, he had to download his ShopSite data,
transfer his domain to our server (where we're running ShopSite 6) and
then reupload his data into the new version 6 store.

Unfortunately, he says downloaded the database "in ShopSite format,
instead of in text format", and now can't upload the database into
ShopSite 6.

Is there really a "ShopSite format" in version 4? I don't see it in the
download options for ShopSite 6.

If there is, does anyone know if there is a quicker way to solve the
problem than transferring the domain back to his server and having him
download it as text this time?

Hoping for a time-saver,

Jessi

Re: Transferring databases between different versions

PostPosted: Thu Apr 10, 2003 1:33 pm
by loren_d_c
The only download/export format for ShopSite products in v4 is the
tab-delimited text file format. However, perhaps he just downloaded the actual
binary .db files instead of exporting through the ShopSite interface.

What operating system was his old ShopSite on? What operating system is his
new ShopSite on? If they both run on the same type of architecture (for
example, both are Intel-based operating systems like Linux, FreeBSD, Windows,
BSDi) then you could just plop the binary database files from the old store
into the new store's data directory, then run an upgrade on his store which
would upgrade the databases to work with the new version.

If the two stores are on different architectures (example, one is Linux, the
other Solaris-Sparc), then the export from the old store then import to the
new store method is your only solution short of sending the binary databases
to ShopSite to be converted or extracted.

-Loren


jessi wrote:

Hello all,

I'm looking for an elegant solution to the following problem:

A ShopSite user I'm responsible for helping is transitioning from ShopSite
4.x to ShopSite 6. To do so, he had to download his ShopSite data,
transfer his domain to our server (where we're running ShopSite 6) and
then reupload his data into the new version 6 store.

Unfortunately, he says downloaded the database "in ShopSite format,
instead of in text format", and now can't upload the database into
ShopSite 6.

Is there really a "ShopSite format" in version 4? I don't see it in the
download options for ShopSite 6.

If there is, does anyone know if there is a quicker way to solve the
problem than transferring the domain back to his server and having him
download it as text this time?

Hoping for a time-saver,

Jessi