Schema Change time from 904 to 905

If using SSD yes that is possible to get it done in a very short time. Conversion times for me were roughly 6 hours for a 4 gig DB. This was with the conversions running on a x32 install.

Feel free to contact me directly if you have any questions.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cubcrafters_it
Sent: Tuesday, June 07, 2011 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Schema Change time from 904 to 905



My schema change from 9.04 to 9.05.605 Progress took just under an hour, with a 3.1 GB backup file.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Nathan Anderson" <naanderson@...> wrote:
>
> A general rule of thumb for how long the schema change will take is one
> hour per GB of your database data file (d1 / mdf) and about the same for
> the mandatory db conversions afterwards
>
>
>
> ~Nathan
>
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of Stephen Freeman
> Sent: Tuesday, June 07, 2011 2:53 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] RE: Schema Change time from 904 to 905
>
>
>
>
>
> Progress.
>
> Server is
>
> OS = 2008 x64
>
> Processors = 2 Intel Xeon Xcore 3 gigahertz
>
> Memory = 32 GB
>
> Workstation is (Pentium 4) 3 gigahertz with 1 GB of memory.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Zac Jason Woodward
> Sent: Tuesday, June 07, 2011 2:48 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] RE: Schema Change time from 904 to 905
>
> Progress or SQL?
>
> If progress, is it x32 or x64?
>
> "Zac" Jason Woodward
> Network Administrator
> Intermountain Electronics, Inc.
> O: 877-544-2291
> M: 435-820-6515
> F: 435-637-9601
> www.ie-corp.com
>
> Creating customer confidence through extraordinary service and
> experienced industry experts.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
> On Behalf Of Stephen Freeman
> Sent: Tuesday, June 07, 2011 1:47 PM
> To: Vantage E Group (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>)
> Subject: [Vantage] Schema Change time from 904 to 905
>
> I've got a 15 GB database that's been running a Schema Change for almost
> 5 hours now. Support says it's going to take a while but can't give me a
> specific time table. For those that have tried it what's been your
> experience?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Click here
> <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
> MGDphu7X+TICvSc7E4isYsJxja7XzW5+rgWl3fOT1a7RlQ==> to report this email
> as spam.
> --------------------------------------------------------
>
> This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group.
>
>
> This message has been scanned for malware by Websense. www.websense.com
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
I've got a 15 GB database that's been running a Schema Change for almost 5 hours now. Support says it's going to take a while but can't give me a specific time table. For those that have tried it what's been your experience?


[Non-text portions of this message have been removed]
Progress or SQL?

If progress, is it x32 or x64?

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Freeman
Sent: Tuesday, June 07, 2011 1:47 PM
To: Vantage E Group (vantage@yahoogroups.com)
Subject: [Vantage] Schema Change time from 904 to 905



I've got a 15 GB database that's been running a Schema Change for almost 5 hours now. Support says it's going to take a while but can't give me a specific time table. For those that have tried it what's been your experience?

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



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

Server is

OS = 2008 x64

Processors = 2 Intel Xeon Xcore 3 gigahertz

Memory = 32 GB

Workstation is (Pentium 4) 3 gigahertz with 1 GB of memory.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Zac Jason Woodward
Sent: Tuesday, June 07, 2011 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Schema Change time from 904 to 905



Progress or SQL?

If progress, is it x32 or x64?

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Stephen Freeman
Sent: Tuesday, June 07, 2011 1:47 PM
To: Vantage E Group (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Schema Change time from 904 to 905

I've got a 15 GB database that's been running a Schema Change for almost 5 hours now. Support says it's going to take a while but can't give me a specific time table. For those that have tried it what's been your experience?

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

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



[Non-text portions of this message have been removed]
I think we were around 6+ hours. DB around 5-6gb, running in a VM with so-so
hardware under it.

On Tue, Jun 7, 2011 at 3:53 PM, Stephen Freeman <stephenf@...> wrote:

>
>
> Progress.
>
> Server is
>
> OS = 2008 x64
>
> Processors = 2 Intel Xeon Xcore 3 gigahertz
>
> Memory = 32 GB
>
> Workstation is (Pentium 4) 3 gigahertz with 1 GB of memory.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Zac Jason Woodward
> Sent: Tuesday, June 07, 2011 2:48 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Schema Change time from 904 to 905
>
>
> Progress or SQL?
>
> If progress, is it x32 or x64?
>
> "Zac" Jason Woodward
> Network Administrator
> Intermountain Electronics, Inc.
> O: 877-544-2291
> M: 435-820-6515
> F: 435-637-9601
> www.ie-corp.com
>
> Creating customer confidence through extraordinary service and experienced
> industry experts.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> Stephen Freeman
>
> Sent: Tuesday, June 07, 2011 1:47 PM
> To: Vantage E Group (vantage@yahoogroups.com<mailto:
> vantage%40yahoogroups.com>)
>
> Subject: [Vantage] Schema Change time from 904 to 905
>
> I've got a 15 GB database that's been running a Schema Change for almost 5
> hours now. Support says it's going to take a while but can't give me a
> specific time table. For those that have tried it what's been your
> experience?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
A general rule of thumb for how long the schema change will take is one
hour per GB of your database data file (d1 / mdf) and about the same for
the mandatory db conversions afterwards



~Nathan



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Freeman
Sent: Tuesday, June 07, 2011 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Schema Change time from 904 to 905





Progress.

Server is

OS = 2008 x64

Processors = 2 Intel Xeon Xcore 3 gigahertz

Memory = 32 GB

Workstation is (Pentium 4) 3 gigahertz with 1 GB of memory.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Zac Jason Woodward
Sent: Tuesday, June 07, 2011 2:48 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: Schema Change time from 904 to 905

Progress or SQL?

If progress, is it x32 or x64?

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of Stephen Freeman
Sent: Tuesday, June 07, 2011 1:47 PM
To: Vantage E Group (vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Schema Change time from 904 to 905

I've got a 15 GB database that's been running a Schema Change for almost
5 hours now. Support says it's going to take a while but can't give me a
specific time table. For those that have tried it what's been your
experience?

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

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

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





Click here
<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
MGDphu7X+TICvSc7E4isYsJxja7XzW5+rgWl3fOT1a7RlQ==> to report this email
as spam.
--------------------------------------------------------

This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group.


This message has been scanned for malware by Websense. www.websense.com


[Non-text portions of this message have been removed]
My schema change from 9.04 to 9.05.605 Progress took just under an hour, with a 3.1 GB backup file.

--- In vantage@yahoogroups.com, "Nathan Anderson" <naanderson@...> wrote:
>
> A general rule of thumb for how long the schema change will take is one
> hour per GB of your database data file (d1 / mdf) and about the same for
> the mandatory db conversions afterwards
>
>
>
> ~Nathan
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Stephen Freeman
> Sent: Tuesday, June 07, 2011 2:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Schema Change time from 904 to 905
>
>
>
>
>
> Progress.
>
> Server is
>
> OS = 2008 x64
>
> Processors = 2 Intel Xeon Xcore 3 gigahertz
>
> Memory = 32 GB
>
> Workstation is (Pentium 4) 3 gigahertz with 1 GB of memory.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Zac Jason Woodward
> Sent: Tuesday, June 07, 2011 2:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] RE: Schema Change time from 904 to 905
>
> Progress or SQL?
>
> If progress, is it x32 or x64?
>
> "Zac" Jason Woodward
> Network Administrator
> Intermountain Electronics, Inc.
> O: 877-544-2291
> M: 435-820-6515
> F: 435-637-9601
> www.ie-corp.com
>
> Creating customer confidence through extraordinary service and
> experienced industry experts.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
> On Behalf Of Stephen Freeman
> Sent: Tuesday, June 07, 2011 1:47 PM
> To: Vantage E Group (vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>)
> Subject: [Vantage] Schema Change time from 904 to 905
>
> I've got a 15 GB database that's been running a Schema Change for almost
> 5 hours now. Support says it's going to take a while but can't give me a
> specific time table. For those that have tried it what's been your
> experience?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Click here
> <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
> MGDphu7X+TICvSc7E4isYsJxja7XzW5+rgWl3fOT1a7RlQ==> to report this email
> as spam.
> --------------------------------------------------------
>
> This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group.
>
>
> This message has been scanned for malware by Websense. www.websense.com
>
>
> [Non-text portions of this message have been removed]
>