Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

SEP11 and SEP12 database on same SQL Server

Created: 11 Feb 2014 • Updated: 11 Feb 2014 | 5 comments
GJCronje's picture
This issue has been solved. See solution.

We are busy upgrading to SEP12. We want to build a new SEP12 Server and migrate clients from SEP11 over a period of months, and host the database on the same SQL Server as SEP11.

 

I would like to know whether it will be a problem if we host the SEP12 database on the same SQL Server.

 

Like SEP11 = sem5 and SEP12 = sem6.

Operating Systems:

Comments 5 CommentsJump to latest comment

SMLatCST's picture

Shouldn't be a problem.

As long as you are careful in your setup and ensure no confusion, there should be no problem hosting DB for different SEPM versions in the same SQL Instance.

pete_4u2002's picture

han't tried.. however should not be an issue, also make sure you have appropriate resource.

Rafeeq's picture

Edit # My bad :)

should not be a problem as long as they are in different db name, default is SEM5.db you can use the different one , He is right

GJCronje's picture

Thanks.. Does it have to be in a different instrance?

SMLatCST's picture

Nopes, they should be fine to share the same instance.  Just be careful which DB you point which SEPM at wink

For added separation, just make sure you use different accounts for each SEPM and DB, so that the account used by SEP11 to access its DB has no rights to the SEP12 DB.

SOLUTION