Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 5 of 5

Thread: Copy Products to new DB

  1. 12-09-2010, 09:41 AM #1
    ZachJ85 is offline Senior Member
    Join Date
    Apr 2010
    Location
    Philadelphia, PA
    Posts
    99

    Question Copy Products to new DB

    We have QA site1 and QA site2. Someone here is adding products and changing products on QA site1, how can we transfer all the products from QA site1 to QA site2?

    I'm open to any ideas, I would assume copy of some DB tables(not sure which).

    The folder/file structure are the exact same on both QA site1 and site2 but sometimes site1 has updated products. I'm trying to avoid re-entering products twice.

    Thanks,
    Zach

    **feel free to ask questions if I wasn't clear or was confusing.
    SQL 2008, Visual Studio 2010
    Source: C#
    Version: AspDotNetStorefront ML 8.0.1.1/8.0.1.1
    Framework: .Net 4.0 (Running)
  2. 12-09-2010, 09:49 AM #2
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    Hello Zach, is it ok to overwrite the existing products etc in your destination database? Also, are you worried about orders or does the destination even have order inofmration that must be kept?

    If not, that is doable using the SQL Management Studio, and you will have to transfer a number of tables:
    - Product
    - ProductVariant
    - ProductCategory
    - ProductSection
    - ProductManufacturer
    - ProductDistributor
    - etc (pretty much any with Product in the name)

    Also, depends on what cart features you are using like CustomerLevels etc...

    Make sure you set identity insert to on and delete the existing in destination...
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)
  3. 12-09-2010, 10:30 AM #3
    ZachJ85 is offline Senior Member
    Join Date
    Apr 2010
    Location
    Philadelphia, PA
    Posts
    99

    Default

    Perfect thanks, that is what I thought for the tables but I wanted another user to support what I was thinking. About your other questions on CustomerLevels, etc.. I never thought about it but I will today.

    Thanks,
    Zach
    SQL 2008, Visual Studio 2010
    Source: C#
    Version: AspDotNetStorefront ML 8.0.1.1/8.0.1.1
    Framework: .Net 4.0 (Running)
  4. 12-09-2010, 11:30 AM #4
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    just remember to always make full DB backups before such moves ;-)
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)
  5. 12-10-2010, 02:36 AM #5
    WebcatchUK is offline Junior Member
    Join Date
    Dec 2010
    Location
    Nottingham, UK
    Posts
    2

    Default

    As jsimacek said, you can copy the tables across and it should work fine
    I've had to do this a few times to copy products over from dev sites to live versions and it's never caused me any problems.