1. Home
  2. Point-Of-Sale Software
  3. RMS GP Integration

RMS GP Integration

I have RMS server on it SQL 2000 And MS Dynamics GP server on it SQL 2005 I need to make clustering using the two servers and just install SQL 2005 engine

So can i use SQL 2005 engine with RMS (Store & HQ) DB? If I can ,from where can i get the MSDE 2005 to install on the stores? And is it recommended to make RMS & GP on the same server?

Reply to
ENG RAMY
Loading thread data ...

I have RMS server on it SQL 2000 And MS Dynamics GP server on it SQL 2005 I need to make clustering using the two servers and just install SQL 2005 engine

So can i use SQL 2005 engine with RMS (Store & HQ) DB? If I can ,from where can i get the MSDE 2005 to install on the stores? And is it recommended to make RMS & GP on the same server?

Reply to
Jeff

is 1.3.1007.

Reply to
ENG RAMY
Reply to
Jeff

If you're talking about creating a failover cluster for SQL Server, you don't need SQL Express, you need SQL Server 2005 ENTERPRISE Edition. You also need some serious hardware including an external storage array that will be shared by the two servers in the cluster. Clustering is a non-trivial exercise...

You can download SQL Server Express and find more about feature differences between editions at:

formatting link

Glenn Adams Tiber Creek C> Eng,

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.