176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

SQL Server eCommerce database re-engineering
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jun 29, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, May 17, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: More than $10,000
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

We have a successful eCommerce system built on the platform of Windows Server 2003, SQL Server 2008, C# ASP.NET web forms.

The database has the correct entities for our business but we believe that its design could become a limiting factor in our growth:

The problems are:
use of GUID data type for nearly all index fields
excessive number of intermediate tables between entities

Our web forms and server processes access the data via T-SQL stored procedures, and what we want is to improve the database in such a way that our web pages and server components will work transparently with the re-engineered database.

Your task is therefore:

Study our database
Suggest a plan and design to re-engineer the database in such a way that we do not have to make software changes i.e. we do not want to disrupt our eCommerce activities
Migrate data from the legacy database into your re-engineered one
Provide scripts to migrate and install the new database on our database servers

Sign in or Register to see more

Job ID: 24295128
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Techphorse is your virtual and remote one-stop shop for all of your IT needs. I call this: "provisioning the full IT stack lifecycle." In plain...
1
  |  
 5.0   |  Private   |  0 Jobs
Bid ID: 24393943  |  Submitted: May 23, 2011 23:02 ET 
Proposal SEALED

 Ukraine  |  
INVITED
NIX Solutions Ltd. is TOP #3 Service Provider with more than 1200+ engineers, 11800 successful completed projects and perfect reviews. We work with...
20
  |  
 4.8   |  $1,837,806 Earnings   |  207 Jobs   |  9 verified credential(s)
Bid ID: 24298098  |  Submitted: May 17, 2011 10:01 ET 
Proposal SEALED

 United States  |  
We're smart, but not so smart that we don't know how to communicate. We're not a bunch of geeks locked away in a basement hacking at something,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 24295976  |  Submitted: May 17, 2011 07:39 ET 
Proposal SEALED

HireRussians      
One or more team members at  are verified.  Learn More
 Russia  |  
13+ years on Elance, 16+ years in software development industry. HireRussians provides safe outsourcing services, secure processes, and top...
15
  |  
 4.7   |  $1,476,612 Earnings   |  101 Jobs   |  15 verified credential(s)
Bid ID: 24295328  |  Submitted: May 17, 2011 06:44 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »