data migration tools for ecommerce

Posted on 2014-07-16
Last Modified: 2016-02-13
we have ecommerce website and database selling products on line and we always receive csv/excel file product information for update. We hope to find a tool we can use for data upload / migration for eCommerce purposes. any ideas?
Question by:ITsolutionWizard
    LVL 21

    Expert Comment

    by:Randy Poole
    Normally you would create a custom importation routine either in SQL Server or a web page so it can do exactly what you need it to do.  Add new items, discontinue items, adjust quantity on hand and price. Etc.
    LVL 14

    Accepted Solution


    If you have SQL then You can try SSIS package which will load the data from any source to the SQL

    IF the CSV / Excel file format will remain same then you can Create SQL query to fetch data from CSV/EXCEL and Load it to the SQL.

    select *
    into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
        'Excel 8.0;Database=D:\testing.xls;HDR=YES',
        'SELECT * FROM [Sheet1$]')

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    SQL Server  2012 Release with lots of Enhancements in Database Engine functions, SSIS, SSRS and some of new services like Data Quality Server and Master Data Service. Of particular interest, and the focus of this Article is SSIS. So, time to elab…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Viewers will learn how the fundamental information of how to create a table.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now