Epicor 9 to 10 migration

Hey Charles,

I'm actually in the middle of the exact same process as you are, but a few steps further along from the sounds of it. I see two differences comparing your process to mine however.

1.) I was told by our CAM that SQL Express is a no-no; we purchased SQL 2012 Standard Runtime (Epicor has a reasonably attractive price point for this). However, I'm not convinced that your error is caused by SQL Express vs Standard; just a heads up for future work.

2.) I'm actually running Epicor 9 and 10 on the same server, which the migration guide recommends doing. However, it's my understanding that they don't *have* to be on the same server, I just took this approach as it potentially rules out variables that could cause errors and in theory should speed the migration process.

A few things to check:

The migration needs to be ran from the E10 server, or wherever you have the E10 administration tools installed.

If you're going to stick with the separate server route, check for full administrative access between the two servers, as well as full write permissions on any directories.

Also, make sure you're using UNC paths…the migration guide is very specific on this; mapped drive letters probably won't work.

That's all I know for now, I've yet to have a successful migration as well, but my issues are with the data in the database =)

-ben
I am attempting to migrate a 9.05.702a data base to a 10.0.700.4
database.  I have the E10 console installed on my Epicor 9 server. 
The E9 server is Windows Server 2008 R2 with SQL 2008 Express
installed as per Epicor's instructions.  The E10 Server is Windows
2012 R2 with SQL 2014 installed. This is my configuration for the
migration:<br>
<img src="cid:part1.01050702.00010502@att.net" alt=""><br>
<br>
When I attempt to migrate I get the following error:<br>
<br>
<big>Error Exception Message: Option &#39;SINGLE_USER&#39; cannot be set in
  database &#39;tempdb&#39;</big>. <br>
<br>
I have no idea what could be causing this.  I have gone over my
configuration many times and I cannot find anything wrong.  I can&#39;t
run the migration from the E10 server because I get the OpenEdge
exited with code 2 message.  From what I have read I need to be
running the migration for my E9 server which I am doing.<br>
<br>
Does anyone have any idea what I am doing wrong?<br>
 <br>
Thanks before hand for any help you can give.<br>
You can't use the TempDB for this.


*Jose C Gomez*


*Software Engineer*

T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Fri, Aug 7, 2015 at 3:52 PM, Charles Carden shadowcar1449@...
[vantage] <vantage@yahoogroups.com> wrote:

>
>
> I am attempting to migrate a 9.05.702a data base to a 10.0.700.4
> database. I have the E10 console installed on my Epicor 9 server. The E9
> server is Windows Server 2008 R2 with SQL 2008 Express installed as per
> Epicor's instructions. The E10 Server is Windows 2012 R2 with SQL 2014
> installed. This is my configuration for the migration:
>
>
> When I attempt to migrate I get the following error:
>
> Error Exception Message: Option 'SINGLE_USER' cannot be set in database
> 'tempdb'.
>
> I have no idea what could be causing this. I have gone over my
> configuration many times and I cannot find anything wrong. I can't run the
> migration from the E10 server because I get the OpenEdge exited with code 2
> message. From what I have read I need to be running the migration for my
> E9 server which I am doing.
>
> Does anyone have any idea what I am doing wrong?
>
> Thanks before hand for any help you can give.
>
>


[Non-text portions of this message have been removed]