Sql server virtualization with centralized client access setup recommendation

Main office and 5, 6 branch offices. Currently each office has a sql server with pharmacy software installed. Sql server 2000 & server 2003 r2 64 bit runs  on servers. At about 15 users from each office access software using xp clients.

Client needs to virtualize or centralize servers in to main office  & setup clients to access servers from branch offices.
High availability method should include in solution.
How many servers do we buy? , which hardware configuration ?
Vmware or hyper-v ? Which method for high availability?
How is storage consideration?
What are the best ways clients can access software in main office? Clints should print to local pos printers.
What are the other things do we consider in this case?
Your any of suggestions greately appreciated
Thank you.
LVL 13
upalakshithaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
have a read of this recent EE post which debates VMware or Microsoft.

http://www.experts-exchange.com/Software/VMWare/Q_27985921.html

As for Best Practices of SQL on VMware

see here

http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

http://communities.vmware.com/docs/DOC-8964

What's your budget?

(it's a large question, you would probably be better off splitting into several, for more Experts to respond!)
0
 
upalakshithaAuthor Commented:
thanks for your valuable input.
still there is no budget. i thought providing full detail will help you to give a solution easily.
ok i will split the question.
0
All Courses

From novice to tech pro — start learning today.