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?