What are the challenges you face when working across database platforms? Take the survey
Options

Advice needed

jay007jay007 Posts: 2
edited April 21, 2014 5:33AM in SQL Compare Previous Versions
I have a MS SQL Database from a POS System. I need to export data to a new POS system ( Blank Database on new POS system) . All I need is Products, Prices and Barcodes. My problem is the barcodes are stored in a different table. I have no problem exporting each table and then importing but I am missing the barcodes as they are in a different table. Can this be done?

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    It sounds like you're probably using SQL Data Compare rather than SQL Compare, and trying to migrate data between two different tables?

    If so, SQL Data Compare can still do this- you'll need to manually map the table / columns correctly to the target DB structure first though. This link should be helpful, but do post back if you're still having trouble.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.