Dump & Load in 6.1

system · December 12, 2007, 12:47pm

Hello Dwight,

The Dump and Load effectively defragments the database and rebuilds the
indices. If your DB has a high scatter factor it will reduce the size of
the d(x) file(s), truncate the BI and improve the system's performance.

Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
D Jones
Sent: Wednesday, December 12, 2007 8:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dump & Load in 6.1

I'm not familiar with this feature. Could someone
please educate me on what this running this function
accomplishes?

Thanks.
Dwight Jones
IRP, Inc.

--- Ari Footlik <ari@... <mailto:ari%40zweig-cnc.com> > wrote:

> Follow-Up:
>
> In the "Data Admin" tool, the options for "Dump" and
> "Load" are
> greyed-out - is this right, or am I missing
> something?
>
> My understanding after some reading from the
> Progress KB is that I dump
> the database defs and data, then load them into a
> new database. Then,
> my guess is, I either tell Vantage to look at the
> new DB, or I rename
> the old DB, rename the new DB, and start the
> services again.
>
> So I think it's those greyed-out selections that are
> my stumbling point
> right now.
>
> Thanks.
>

----------------------------------------------------------

> Ari Footlik
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On

Behalf

> Of Ari Footlik
> Sent: Wednesday, December 12, 2007 9:46 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Dump & Load in 6.1
>
>
>
> My understanding is that a best practice would be to
> perform this
> operation once per year, but it has never been done
> here. We're going
> to be upgrading to v8.xx soon, and I think it'd be a
> good idea to D&L
> before we begin the upgrade/conversion.
>
> Could someone please describe for me the procedure
> for performing this
> operation, including the tools to use and the steps
> necessary to
> successfully execute the whole thing? I have an idea
> of where to look
> and what tools to use, but something isn't clicking
> as to how to get all
> the pieces lined up.
>
> Thanks.
> --Ari
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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

system · December 11, 2007, 10:09am

Does anyone know if MS SQL Server Express 2005 will run Service Connect?

We have installed SQL Server Express, but receive the following error
when installing Servic Connect and it is trying to create the database.

Cannot connect to the database. SQLOLEDB Error=-2147467259,
Description: SQL Server does not exist or access denied.

We can connect to the database by using the SQL Server Management Tool.

Any insight would be appreciated.

Thanks
Clinton Edwards
Trinity Yachts

system · December 12, 2007, 2:02am

Yes, ESC will run on SQL Express 2005 ...

What version of ESC are you installing?

--- In vantage@yahoogroups.com, "mustardbuzzards" <c.edwards@...> wrote:
>
> Does anyone know if MS SQL Server Express 2005 will run Service Connect?
>
> We have installed SQL Server Express, but receive the following error
> when installing Servic Connect and it is trying to create the database.
>
> Cannot connect to the database. SQLOLEDB Error=-2147467259,
> Description: SQL Server does not exist or access denied.
>
> We can connect to the database by using the SQL Server Management Tool.
>
> Any insight would be appreciated.
>
> Thanks
> Clinton Edwards
> Trinity Yachts
>

system · December 12, 2007, 7:30am

Need to append '\SQLExpress' after your SQL Server specification during
the install.

I got this by contacting Epicor Support. Not mentioned in the
documentation anywhere!

Manufacturing Medical Innovation (r)

Bruce VanderSchaaf
Sr. Programmer Analyst

Synovis Interventional Solutions, Inc.
475 Apollo Drive
Lino Lakes, MN 55014-1093
<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=475+Apollo+Drive&csz=Lin
o+Lakes%2C+MN+55014-1093&country=us>

bvanderschaaf@... <mailto:bvanderschaaf@...>
AIM: vcs3455

tel:
fax:
mobile:

(651) 792-8575
<http://www.plaxo.com/click_to_call?src=jj_signature&To=(651)+792-8575&E
mail=bruce.vanderschaaf@...>
(651) 792-8675
(612) 810-4257
<http://www.plaxo.com/click_to_call?src=jj_signature&To=(612)+810-4257&E
mail=bruce.vanderschaaf@...>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mustardbuzzards
Sent: Tuesday, December 11, 2007 9:09 AM
To: vantage@yahoogroups.com
Subject: * [Vantage] Service Connect 8.1/8.2

Does anyone know if MS SQL Server Express 2005 will run Service Connect?

We have installed SQL Server Express, but receive the following error
when installing Servic Connect and it is trying to create the database.

Cannot connect to the database. SQLOLEDB Error=-2147467259,
Description: SQL Server does not exist or access denied.

We can connect to the database by using the SQL Server Management Tool.

Any insight would be appreciated.

Thanks
Clinton Edwards
Trinity Yachts

This e-mail (including any attachments) may contain confidential, proprietary and/or privileged information for the sole use of the intended recipient. Any unauthorized disclosure or use by others is prohibited. If you are not the intended recipient and received this e-mail in error, please notify the sender and delete this e-mail from your system.

Disclaimer added by CodeTwo Exchange Rules
http://www.codetwo.com

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

system · December 12, 2007, 9:18am

8.1 CD and 8.2 downloaded from Epicor

--- In vantage@yahoogroups.com, "Cathlene Fishman" <fish@...> wrote:
>
> Yes, ESC will run on SQL Express 2005 ...
>
> What version of ESC are you installing?
>
> --- In vantage@yahoogroups.com, "mustardbuzzards" <c.edwards@>
wrote:
> >
> > Does anyone know if MS SQL Server Express 2005 will run Service
Connect?
> >
> > We have installed SQL Server Express, but receive the following
error
> > when installing Servic Connect and it is trying to create the
database.
> >
> > Cannot connect to the database. SQLOLEDB Error=-2147467259,
> > Description: SQL Server does not exist or access denied.
> >
> > We can connect to the database by using the SQL Server
Management Tool.
> >
> > Any insight would be appreciated.
> >
> > Thanks
> > Clinton Edwards
> > Trinity Yachts
> >
>

system · December 12, 2007, 9:28am

Where is this done? Is there field that is used or is this a behind
the scenes modification?

Sorry for the confusion, but we are new to Vantage.
Thanks for you help.

--- In vantage@yahoogroups.com, "VanderSchaaf, Bruce $IS$"
<BVanderSchaaf@...> wrote:

>
> Need to append '\SQLExpress' after your SQL Server specification

during

> the install.
>
>
>
> I got this by contacting Epicor Support. Not mentioned in the
> documentation anywhere!
>
>
>
>
>
> Manufacturing Medical Innovation (r)
>
>
>
> Bruce VanderSchaaf
> Sr. Programmer Analyst
>
> Synovis Interventional Solutions, Inc.
> 475 Apollo Drive
> Lino Lakes, MN 55014-1093
> <http://maps.yahoo.com/py/maps.py?

Pyt=Tmap&addr=475+Apollo+Drive&csz=Lin

> o+Lakes%2C+MN+55014-1093&country=us>
>
> bvanderschaaf@... <mailto:bvanderschaaf@...>
> AIM: vcs3455
>
> tel:
> fax:
> mobile:
>
> (651) 792-8575
> <http://www.plaxo.com/click_to_call?src=jj_signature&To=(651)+792-

8575&E

> mail=bruce.vanderschaaf@...>
> (651) 792-8675
> (612) 810-4257
> <http://www.plaxo.com/click_to_call?src=jj_signature&To=(612)+810-

4257&E

> mail=bruce.vanderschaaf@...>
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of mustardbuzzards
> Sent: Tuesday, December 11, 2007 9:09 AM
> To: vantage@yahoogroups.com
> Subject: * [Vantage] Service Connect 8.1/8.2
>
>
>
> Does anyone know if MS SQL Server Express 2005 will run Service

Connect?

>
> We have installed SQL Server Express, but receive the following

error

> when installing Servic Connect and it is trying to create the

database.

>
> Cannot connect to the database. SQLOLEDB Error=-2147467259,
> Description: SQL Server does not exist or access denied.
>
> We can connect to the database by using the SQL Server Management

Tool.

>
> Any insight would be appreciated.
>
> Thanks
> Clinton Edwards
> Trinity Yachts
>
>
>
>
>
>
>
>
> This e-mail (including any attachments) may contain confidential,

proprietary and/or privileged information for the sole use of the
intended recipient. Any unauthorized disclosure or use by others is
prohibited. If you are not the intended recipient and received this
e-mail in error, please notify the sender and delete this e-mail
from your system.

>
>
>
> Disclaimer added by CodeTwo Exchange Rules
> http://www.codetwo.com
>
>
> [Non-text portions of this message have been removed]
>

system · December 12, 2007, 9:32am

Good Morning Everyone,

Is any one using more then one applied labor account? We are setting up
our system and it looks like we will need to use more then one.

How are you setting up the Applied labor and overhead (Offset account).
It looks like one applied labor account and that will not work for us.

1 hour of labor at $30.00 and $40.00 overhead on a Meter department job.
Our current process is:

Debits

Inventory

120-1330-00 WIP Labor 30.00

120-1331-00 WIP Overhead 40.00

Credits

Income Statement

120-5400-00 Labor Applied 30.00

120-6900-00 Overhead Applied 40.00

This changes for each department.

110

116

120

130

240

Any Suggestions?

Thank you,

Dale Kalsow | Information Technologies Director
____________________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... | * http://determan.com/

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

system · December 12, 2007, 10:09am

Got it thanks. Needs to be added to server name.

We are now installing on the patches/service packs.

--- In vantage@yahoogroups.com, "mustardbuzzards" <c.edwards@...>
wrote:

>
> Where is this done? Is there field that is used or is this a

behind

> the scenes modification?
>
> Sorry for the confusion, but we are new to Vantage.
> Thanks for you help.
>
> --- In vantage@yahoogroups.com, "VanderSchaaf, Bruce $IS$"
> <BVanderSchaaf@> wrote:
> >
> > Need to append '\SQLExpress' after your SQL Server specification
> during
> > the install.
> >
> >
> >
> > I got this by contacting Epicor Support. Not mentioned in the
> > documentation anywhere!
> >
> >
> >
> >
> >
> > Manufacturing Medical Innovation (r)
> >
> >
> >
> > Bruce VanderSchaaf
> > Sr. Programmer Analyst
> >
> > Synovis Interventional Solutions, Inc.
> > 475 Apollo Drive
> > Lino Lakes, MN 55014-1093
> > <http://maps.yahoo.com/py/maps.py?
> Pyt=Tmap&addr=475+Apollo+Drive&csz=Lin
> > o+Lakes%2C+MN+55014-1093&country=us>
> >
> > bvanderschaaf@ <mailto:bvanderschaaf@>
> > AIM: vcs3455
> >
> > tel:
> > fax:
> > mobile:
> >
> > (651) 792-8575
> > <http://www.plaxo.com/click_to_call?src=jj_signature&To=(651)

+792-

> 8575&E
> > mail=bruce.vanderschaaf@>
> > (651) 792-8675
> > (612) 810-4257
> > <http://www.plaxo.com/click_to_call?src=jj_signature&To=(612)

+810-

> 4257&E
> > mail=bruce.vanderschaaf@>
> >
> >
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]

On

> Behalf
> > Of mustardbuzzards
> > Sent: Tuesday, December 11, 2007 9:09 AM
> > To: vantage@yahoogroups.com
> > Subject: * [Vantage] Service Connect 8.1/8.2
> >
> >
> >
> > Does anyone know if MS SQL Server Express 2005 will run Service
> Connect?
> >
> > We have installed SQL Server Express, but receive the following
> error
> > when installing Servic Connect and it is trying to create the
> database.
> >
> > Cannot connect to the database. SQLOLEDB Error=-2147467259,
> > Description: SQL Server does not exist or access denied.
> >
> > We can connect to the database by using the SQL Server

Management

> Tool.
> >
> > Any insight would be appreciated.
> >
> > Thanks
> > Clinton Edwards
> > Trinity Yachts
> >
> >
> >
> >
> >
> >
> >
> >
> > This e-mail (including any attachments) may contain

confidential,

> proprietary and/or privileged information for the sole use of the
> intended recipient. Any unauthorized disclosure or use by others

is

> prohibited. If you are not the intended recipient and received

this

> e-mail in error, please notify the sender and delete this e-mail
> from your system.
> >
> >
> >
> > Disclaimer added by CodeTwo Exchange Rules
> > http://www.codetwo.com
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

system · December 12, 2007, 10:45am

My understanding is that a best practice would be to perform this
operation once per year, but it has never been done here. We're going
to be upgrading to v8.xx soon, and I think it'd be a good idea to D&L
before we begin the upgrade/conversion.

Could someone please describe for me the procedure for performing this
operation, including the tools to use and the steps necessary to
successfully execute the whole thing? I have an idea of where to look
and what tools to use, but something isn't clicking as to how to get all
the pieces lined up.

Thanks.
--Ari

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

system · December 12, 2007, 11:51am

Follow-Up:

In the "Data Admin" tool, the options for "Dump" and "Load" are
greyed-out - is this right, or am I missing something?

My understanding after some reading from the Progress KB is that I dump
the database defs and data, then load them into a new database. Then,
my guess is, I either tell Vantage to look at the new DB, or I rename
the old DB, rename the new DB, and start the services again.

So I think it's those greyed-out selections that are my stumbling point
right now.

Thanks.
------------------------------------------------------------------------
Ari Footlik

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ari Footlik
Sent: Wednesday, December 12, 2007 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Dump & Load in 6.1

My understanding is that a best practice would be to perform this
operation once per year, but it has never been done here. We're going
to be upgrading to v8.xx soon, and I think it'd be a good idea to D&L
before we begin the upgrade/conversion.

Could someone please describe for me the procedure for performing this
operation, including the tools to use and the steps necessary to
successfully execute the whole thing? I have an idea of where to look
and what tools to use, but something isn't clicking as to how to get all
the pieces lined up.

Thanks.
--Ari

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

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

system · December 12, 2007, 11:55am

I'm not familiar with this feature. Could someone
please educate me on what this running this function
accomplishes?

Thanks.
Dwight Jones
IRP, Inc.

--- Ari Footlik <ari@...> wrote:

> Follow-Up:
>
> In the "Data Admin" tool, the options for "Dump" and
> "Load" are
> greyed-out - is this right, or am I missing
> something?
>
> My understanding after some reading from the
> Progress KB is that I dump
> the database defs and data, then load them into a
> new database. Then,
> my guess is, I either tell Vantage to look at the
> new DB, or I rename
> the old DB, rename the new DB, and start the
> services again.
>
> So I think it's those greyed-out selections that are
> my stumbling point
> right now.
>
> Thanks.
>

------------------------------------------------------------------------

> Ari Footlik
>
> ________________________________
>
> From: vantage@yahoogroups.com
> [mailto:vantage@yahoogroups.com] On Behalf
> Of Ari Footlik
> Sent: Wednesday, December 12, 2007 9:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Dump & Load in 6.1
>
>
>
> My understanding is that a best practice would be to
> perform this
> operation once per year, but it has never been done
> here. We're going
> to be upgrading to v8.xx soon, and I think it'd be a
> good idea to D&L
> before we begin the upgrade/conversion.
>
> Could someone please describe for me the procedure
> for performing this
> operation, including the tools to use and the steps
> necessary to
> successfully execute the whole thing? I have an idea
> of where to look
> and what tools to use, but something isn't clicking
> as to how to get all
> the pieces lined up.
>
> Thanks.
> --Ari
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>

____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

system · December 12, 2007, 12:12pm

Ari,

I've completed D&L in both 6.1 and 8.0.

You should request the D&L kit from support. You'll want the
MkBinaryDmp.P procedure. The kit includes a 20 page BinaryDumpLoad.doc
that steps you through the entire process -- things like how to open
Data Administration with -RX so you can write to the database...

I often find fault with their documentation & guides but this one is
spot on!

Regards, Lee

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ari Footlik
Sent: Wednesday, December 12, 2007 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dump & Load in 6.1

Follow-Up:

In the "Data Admin" tool, the options for "Dump" and "Load" are
greyed-out - is this right, or am I missing something?

My understanding after some reading from the Progress KB is that I dump
the database defs and data, then load them into a new database. Then,
my guess is, I either tell Vantage to look at the new DB, or I rename
the old DB, rename the new DB, and start the services again.

So I think it's those greyed-out selections that are my stumbling point
right now.

Thanks.
----------------------------------------------------------
Ari Footlik

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ari Footlik
Sent: Wednesday, December 12, 2007 9:46 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dump & Load in 6.1

My understanding is that a best practice would be to perform this
operation once per year, but it has never been done here. We're going
to be upgrading to v8.xx soon, and I think it'd be a good idea to D&L
before we begin the upgrade/conversion.

Could someone please describe for me the procedure for performing this
operation, including the tools to use and the steps necessary to
successfully execute the whole thing? I have an idea of where to look
and what tools to use, but something isn't clicking as to how to get all
the pieces lined up.

Thanks.
--Ari

Topic		Replies	Views
Progress Dump & Load Question Yahoo Archive	6	620	June 7, 2013
Dump and load Yahoo Archive	5	308	December 18, 2001
Dump & Load of the Data Base Yahoo Archive	2	346	November 15, 2010
Dump and Load? Yahoo Archive	2	271	July 5, 2001
More dump and load problems Yahoo Archive	2	305	January 8, 2003

Dump & Load in 6.1

Related Topics