Seeking a professional to develop a way to change a key field in MS SQL database in order to link to an offline database for importing.
We are using [url removed, login to view] eCommerce software on our website at www.TriTekElectronics.com. The database is hosted at Webhost4life.
All items in our online database are generated from our offline POS system. Each item has a "product code" that acts as a key field to link the online and offline items so we can update pricing and quanitity on hand. Recently, all of the product codes in our offline database were altered and no longer "link" to our online database items. This means we can not currently update pricing or QOH.
We are seeking an individual to edit our SQL database "product code" key field in order to re-enable importing. We have an Excel spreadsheet that contains a cross-reference from the old product code to the new product code. Essentially, all data in the key field in the online database must be changed to match the new product code data. There are about 20,000 items in the databse.
20 pekerja bebas membida secara purata $145 untuk pekerjaan ini
Dear Sir, I have experience in MS SQL for more than 4-5 ys...and with more informtion on wht u want i can get it done for you.. Please see PM for my profile... Monosoft..
Please provide me the Full details. As i am working as a DBA and i can handle this task very easily. Looking for positive response. Regards Parvinder Pal