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.
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]