I gang

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 "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.

Færdigheder: .NET, ASP, Databehandling, Excel, Projekt Ledelse

Se mere: storefront asp net, storefront asp, product pricing spreadsheet, old database, database website software, code offline, sqlserver offline database tasks, cyberstrike online script, database copied, change item sql database, csharp gui sql database, sql script database changes, changes database sql, years experience database, online sql, on sql, website sql, website pos, sql software, sql database website, sql data, sql code, sql c, online pos, develop database

Om arbejdsgiveren:
( 26 bedømmelser ) Mesa, United States

Projekt-ID: #315235

Tildelt til:

Mastersan

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 field Mere

$30 USD på 1 dag
(1 bedømmelse)
1.0

20 freelancere byder i gennemsnit $145 for dette job

sikandermandal

Please See PMB.

$250 USD på 1 dag
(18 bedømmelser)
5.2
snuwanlk

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..

$100 USD in 5 dage
(4 bedømmelser)
3.0
EmailSolutions

Please check PMB for details, Thank you

$150 USD in 2 dage
(0 bedømmelser)
0.0
chaitali007

I can take care of this thing. please touch base.

$200 USD in 10 dage
(0 bedømmelser)
0.0
Valentine23New

Hello, we have rich experience in .NET based software development, including good experience with SQL Server data processing. Please, check PM.

$150 USD in 2 dage
(0 bedømmelser)
0.0
Ushasubramanian

Hi, We The Mnemonics Technologies experienced in Web Hosting, Web Template Designing , Logo Designing, Flash MX, Photoshop CS, HTML, DHTML, ASP, PHP, VB6.0, VB Script, Java Script, AJAX, MS SQL Server, MS Access, ASP.N Mere

$250 USD in 158 dage
(0 bedømmelser)
0.0
amgadali

I can create for you an application in less than aday to generate update script for any fields at any table using your Excel sheet

$50 USD på 1 dag
(0 bedømmelser)
0.0
parvinderpal

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

$70 USD in 4 dage
(0 bedømmelser)
0.0
heliossolutions

Hi, Please check the PMB for details.

$100 USD in 15 dage
(0 bedømmelser)
0.0
intacto

Ready to do this simple job. Details in PM.

$50 USD på 1 dag
(0 bedømmelser)
0.0
pablosanz

I can do it. Check PM.

$150 USD på 1 dag
(0 bedømmelser)
0.0
patea

is it MS SQLserver 2000/2005.? i think l can handle this, but only if after u show me the details.

$150 USD in 5 dage
(0 bedømmelser)
0.0
padisah

I can do this, through a transact sql procedure. Details in PM

$150 USD in 2 dage
(0 bedømmelser)
0.0
cyberstrike

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 Mirage Mere

$250 USD in 3 dage
(0 bedømmelser)
0.0
ranjan74

I am a MS SQL server expert, 12 yrs experience in database development /admin, data processing & analysis.

$120 USD in 7 dage
(0 bedømmelser)
0.0
cosmoinfosys2008

Dear Sir/Madam, Please check PMB for details. With Best Regards.

$225 USD in 5 dage
(0 bedømmelser)
0.0
bruce1953

I can design and implement an algorithm to do this for you. I am a Ph.D. in Computer Science and have over 30 years experience. Thanks!

$250 USD in 30 dage
(0 bedømmelser)
0.0
yuliwd

Hi, I can help fixing your database. Let me do it..

$120 USD in 3 dage
(0 bedømmelser)
2.9
kamaldesai2004

Hi, I am very confident about the job and can do it.

$75 USD in 2 dage
(0 bedømmelser)
0.0