Copy Database?

Yahoo Archive
1
Thank you very much for your reply! Will try this right away.

Thanks,

Matt

--- In vantage@yahoogroups.com, "Mario Aguirre" <maguirre@l...>
wrote:
> Matt,
>
> There is a command to copy the database from one location to
another. I
> only used it once when updating from 5.1 to 5.2. My suggestion is
to
> create your test database in Progress Explorer, use the back up
> generated on line to restore the live database into the test
database.
> You will find out that it is good to have all of the above done
from the
> beginning because you are going to needed. You need on-line back
ups and
> you will need a restore to test whenever they ask you to "renew"
the
> data.
>
> The command is procopy source target. Provide a complete physical
path.
> Stop the database before using the command. I will consult with
Epicor
> prior to do either one.
>
> Mario Aguirre
> Lakin General Corporation, Inc.
>
>
> ________________________________
>
> From: msgvantage [mailto:bullseye@t...]
> Sent: Monday, April 11, 2005 1:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Copy Database?
>
>
>
> Hi all,
>
> Can someone point me in the right direction to copy our
> production 'mfgsys' database to a testing database?
>
> It is a new install, so we have no real data to worry about, I
just
> need to ahve a test db so we're not 'learning' in our production
db,
> or the training db.
>
> I can copy the SQL DB, and create a new db in progress.. just
don't
> know how to get the schema created to link the two..
>
> Thanks,
>
> Matt
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
2
Hi all,

Can someone point me in the right direction to copy our
production 'mfgsys' database to a testing database?

It is a new install, so we have no real data to worry about, I just
need to ahve a test db so we're not 'learning' in our production db,
or the training db.

I can copy the SQL DB, and create a new db in progress.. just don't
know how to get the schema created to link the two..

Thanks,

Matt
3
There is a file in the mfgsys61 directory (toward the bottom) that will
explain everything in detail.

It's a text file called mfgbkup.txt

HTH,

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: msgvantage [mailto:bullseye@...]
Sent: Monday, April 11, 2005 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Copy Database?



Hi all,

Can someone point me in the right direction to copy our
production 'mfgsys' database to a testing database?

It is a new install, so we have no real data to worry about, I just
need to ahve a test db so we're not 'learning' in our production db,
or the training db.

I can copy the SQL DB, and create a new db in progress.. just don't
know how to get the schema created to link the two..

Thanks,

Matt






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

There is a command to copy the database from one location to another. I
only used it once when updating from 5.1 to 5.2. My suggestion is to
create your test database in Progress Explorer, use the back up
generated on line to restore the live database into the test database.
You will find out that it is good to have all of the above done from the
beginning because you are going to needed. You need on-line back ups and
you will need a restore to test whenever they ask you to "renew" the
data.

The command is procopy source target. Provide a complete physical path.
Stop the database before using the command. I will consult with Epicor
prior to do either one.

Mario Aguirre
Lakin General Corporation, Inc.


________________________________

From: msgvantage [mailto:bullseye@...]
Sent: Monday, April 11, 2005 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Copy Database?



Hi all,

Can someone point me in the right direction to copy our
production 'mfgsys' database to a testing database?

It is a new install, so we have no real data to worry about, I just
need to ahve a test db so we're not 'learning' in our production db,
or the training db.

I can copy the SQL DB, and create a new db in progress.. just don't
know how to get the schema created to link the two..

Thanks,

Matt






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Excellent! Thank you very much.

Matt

--- In vantage@yahoogroups.com, "Manasa Reddy" <mreddy@c...> wrote:
> There is a file in the mfgsys61 directory (toward the bottom) that
will
> explain everything in detail.
>
> It's a text file called mfgbkup.txt
>
> HTH,
>
> M. Manasa Reddy
> ERP Specialist
> Crestview Aerospace Corporation
> Email: mreddy@c...
> Phone: (850) 682-2746 x 272
>
>
> -----Original Message-----
> From: msgvantage [mailto:bullseye@t...]
> Sent: Monday, April 11, 2005 1:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Copy Database?
>
>
>
> Hi all,
>
> Can someone point me in the right direction to copy our
> production 'mfgsys' database to a testing database?
>
> It is a new install, so we have no real data to worry about, I
just
> need to ahve a test db so we're not 'learning' in our production
db,
> or the training db.
>
> I can copy the SQL DB, and create a new db in progress.. just
don't
> know how to get the schema created to link the two..
>
> Thanks,
>
> Matt
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> -------------------------------------------------------------------
---------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
>
> [Non-text portions of this message have been removed]