Cleaning up a SQL Server 2005 Database
**************************************
I write a proposal based in the information that you provide.
I have a vast experience in design, develop and administering DBs. If you want you can write me to discuss some details about this job.
Best regards
Eng. Cabalo
1. Analyzing database structure
Three days.
Study the database diagrams. And see the complete list of tables and stored procedures.
2. Checking relationships between tables
One day. Checking existing relationships.
Checking for lacking relationships? Depend on documentation that you have and the nemotecnic names of the tables if documentation is "poor".
3. Checking and improving the naming of tables, stored procedures and functions
Three days ( 75 tables and 100 stored procedures ).
I work based in a convention with names that is easily aplicable in any case.
4. Checking and improving of database diagram
Three days (estimation).
5. Writing documentation.
Five days (estimation).
Once finalized the previos "steps" ( in particular 4 ) this must to take me less that 5 days.
1. We prefer to find developers in the area of LVIV, Ukraine
Sorry, I live in Uruguay / South America, but hope that you choose me.
2. You need to be able to work with ASP.NET 2.0 , C#, AJAX, SQL server 2005
NO problem. In particular I am preparing the certification in SQL Server 2005.
3. You need to be able to work dedicated on this project
I can dedicate too many hours to your project every day to complying with the commitment expressed in "days" that I realize in each step.