selective sync

flotronicsflotronics Posts: 3
edited August 20, 2014 11:39AM in SQL Compare Previous Versions
Hello
I am relatively new with my experience with SQL, ASP etc. Apologies if the answer is buried here someplace.

I work for a company with an existing online store. The software that drives it is trash. I can't abaondon it completely as the software also runs the company's back end, inventory control, accounting etc. I did install NOPCommerce but of course it builds it's own tables. The company SQL tables are in the 100s, but aside from the basics such as name, address... I need to have list price, current price and inventory count.
My question is, with "SQL Data Compare" can I:
1. Pick/choose only the tables and columns within the tables to sync?
2. Do table and column names have to match or can they be mapped?

Thanks
~Rick

Comments

  • Eddie DEddie D Posts: 1,462 Rose Gold 3
    Thank you for your forum.

    The answer to both you questions is yes.
    My question is, with "SQL Data Compare" can I:
    1. Pick/choose only the tables and columns within the tables to sync?
    When creating your SQL Data Compare project or edit an existing project ->Select the 'Table & views' tab and select tables and views you wish to compare.
    2. Do table and column names have to match or can they be mapped?
    Edit the project and select the 'Object Mapping' tab.

    I recommend that you evaluate SQL Data Compare in a test environment to see if it meets your requirements. Also always take a backup of the target database before you run the deployment process. You can always then restore the target back the situation it was in prior to the deployment.

    The SQL Data Compare help information can be found HERE.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Excellent - thank you.
    ~Rick
Sign In or Register to comment.