September 8, 2008 at 3:23 am
Hi Experts,
Can anyone please give me some tips on the below
1. How to analysis an existing database in MS-SQL.
2. Identifying the applications that are sharing the database.
3. Identifying the information shared by each application with this database.
4. How to list the disadvantages in the current database
5. Analyse the possibility of using AD(please tell me what is AD :w00t:) instead of existing database.
6. How to design database considering the impact on the existing application sharing the Information
7. Detail out the level of impact of the new design on the new applications
8. Solution to address the new database changes in the existing application
Thanks in Advance
September 8, 2008 at 8:02 am
Hire someone who has those skills, probably as a contractor, and have them do it for you.
What you're asking is a fairly complex project (depending on the databases and applications) that could take anywhere from 1 day (very simple database with very simple application) to several months. And that's for someone who's got expertise in that field.
Expect a month or more, minimum. It'll probably take a few days just to figure out how long it's going to take, actually.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 8, 2008 at 8:25 am
What's the purpose behind this? Redesigning a database that's in use is not something that I see done often. It can require a lot of time and money and, unless you have specific goals, it can easily achieve nothing.
AD usually refers to Active Directory. Doesn't make sense in that context though, as you can't replace a database with AD.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2008 at 11:12 pm
Thanks 2 ALL 😀
September 10, 2008 at 6:55 am
I'm with GSquared on this one. If you are asking multiple open-ended questions like that it is almost certain that you do not have the skills, training or experience to answer them. And you simply cannot garner those skills, etc, in anything less than many, many months (if not years) of dedicated time. Hire a consultant, and learn from him/her during their work for your company.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply