Database Question

[igavemybest]

First, Dataport is not working for me, I am running Windows 7 and I guess they dont get along.

I am trying to move tables from an old database to a new one. I need to know what tables contain all the products and variants. I moved the following tables, but there is no dropdown box for the variants and the SKU is missing on all the products. Please help! What am I missing?

1. ac_CatalogNodes (2084 records)
2. ac_Categories (90 records)
3. ac_CategoryParents (230 records)
4. ac_ProductReviews (2 records)
5. ac_Products (2006 records)
6. ac_ProductVariants (7750 records)
7. ac_WishListItems (49 records)

[AbleMods]

Is that even possible? I don't see how that would ever work - all the referential integrity would go down the drain. Baskets, wishlists, orderitems, reviews, kits, volume discounts, coupons etc. Everything ties back to products.

As far as variants go, you missed ProductOptions, Options, and OptionChoices. I believe variants use those as well. If you have kits, you're missing another 4-5 tables.

It would seem far less risky to find an XP machine and Dataport it.

[mazhar]

First, Dataport is not working for me, I am running Windows 7 and I guess they dont get along.

I am trying to move tables from an old database to a new one. I need to know what tables contain all the products and variants. I moved the following tables, but there is no dropdown box for the variants and the SKU is missing on all the products. Please help! What am I missing?

1. ac_CatalogNodes (2084 records)
2. ac_Categories (90 records)
3. ac_CategoryParents (230 records)
4. ac_ProductReviews (2 records)
5. ac_Products (2006 records)
6. ac_ProductVariants (7750 records)
7. ac_WishListItems (49 records)

DataPort requires .NET Framework, make sure that on Windows 7 you have .NET Framework 2.0 installed before installing DataPort. Also are you able to install it correctly? What is your dataport version, DataPort 7.0.3? beta or full?