Untitled Document
Microsoft Dynamics RMS Experts
  Register   Login
 Search
RMS Experts
 
  You are Here: Dynamics RMS Community ... Dynamics RMS and POS Forums
 
RMS and POS Forums
Subject: SQL 2008

You are not authorized to post a reply.   
Author Messages
jconway
Posts:1

03/31/2010 12:00 PM Alert 

hello-

i have a HQ and 5 store operation and the HQ database is nearing the 4gb size limit for SQL 2005 (free version).  this is the same version i have on store POS (but we're not running in to the size problem there to date).  my question is what version of SQL 2008 would be recommended - standard, workgroup, etc?  is this as simple as loading the software and upgrading the existing version?  Are there any issues with running HQ and stores on different versions of SQL?

 

Thanks,

 

Jim

 

Mixer
Posts:69

03/31/2010 12:05 PM Alert 
SQL 2008 Workgroup Edition will do. You will need to backup the HQ database in case you need to restore it later. While upgrading should take care of the db migration, it is better if you work with a technical person who knows what they are doing. Perhaps, your RMS VAR?
Besides, if the stores do not run into the size problem, they can well stay on SQL 2005 Express - that wouldn't cause any problems with your HQ running SQL 2008.
You are not authorized to post a reply.



ActiveForums 3.6
Sponsor
Get RMS Training Today
Get RMS Training today!
(c) 2006-2012 Retail Hero ®