SQL database changes

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 &quot;product code&quot; 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 &quot;link&quot; 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 &quot;product code&quot; 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.

Mencari peluang untuk membuat duit?

Dianugerahkan kepada:

Just provide me your XLS file, and loginpassword to your database. I will provide scripts to replace your keys with new ones. Also, the following action will be performed:
Your old keys will be saved to separate fieldLagi

My bid is $100/hr; if the project extends over 7 hours then the price drops to $70/hr thereon for that given project.
I have worked on some of the largest SQL Server 2000 and 2005 servers in the world for MGM MirageLagi