New Test database

Yahoo Archive
1
I just doing it so I can run some test without having any jobs, po's or so inadvertently affecting it.

Thanks,
Jasper

-----Original Message-----
From: Michael Barry [mailto:mbarry@...]
Sent: Thursday, October 06, 2005 10:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] New Test database


Jasper,

Then there is plan B. Make a duplicate database and delete out the data
that you don't need. Equally tedious but a little less time consuming since
it doesn't involve selective dump and load operations.

The remaining question is, however, what are you trying to accomplish? Are
you starting a new company and don't want to migrate the transactional
history from the first or are you trying to remove unwanted history from an
existing company?

Regards,

Michael

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


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
todd Anderson
Sent: Thursday, October 06, 2005 6:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] New Test database

Jasper,

Did it about 4 years ago with a V4 database so yes it can be done.

You'll need the Progress database export/import tools.

Make a list of all master tables in Vantage. Like - customer, vendor, part,
salesperson, etc. Then sequence them as either prime tables or secondary
tables. Prime tables would be vendor, part, customer, etc. Secondary
tables would be tables like salesperson which provide entries that can be
used in the prime tables.

Then export all of the tables you need. Setup the new database and
configure the company info as required. (You can load any of the master
tables that you exported into Access if you want to trim them to active only
entries or ??? In our case we exported the parts/bom info and then trimmed
out all items that had not been used in the last 2 years which reduced the
size by 60-70%.)

When you load the data into the new database - load the minor, secondary
tables first. So before you load the customer table make sure you load the
salespeople minor table first otherwise the customer table will have entries
that don't match.

We pulled over basically all of the master tables having trimmed out the
junk we didn't need.

This isn't hard to do. It is tedious. You have to map out and sequence the
tables carefully.

As I recollect it took me a couple of weeks to figure it out and make the
transfer. Reloading the info by hand would have taken 1 yr+ in man-months
so it made sense to do it.

New database was very small and we trimmed out 90% of the old crap in the
process.

Todd Anderson




_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Thursday, October 06, 2005 7:25 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] New Test database


Is there a way to create a new database but import all our parts list and
vendors but with NO Sales orders, PO's and Jobs.

Is there an easy way to do this?

Thanks,
Jasper


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



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



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.


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



------------------------ Yahoo! Groups Sponsor --------------------~--> Fair
play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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














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
2
Is there a way to create a new database but import all our parts list and vendors but with NO Sales orders, PO's and Jobs.

Is there an easy way to do this?

Thanks,
Jasper


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

Then there is plan B. Make a duplicate database and delete out the data
that you don't need. Equally tedious but a little less time consuming since
it doesn't involve selective dump and load operations.

The remaining question is, however, what are you trying to accomplish? Are
you starting a new company and don't want to migrate the transactional
history from the first or are you trying to remove unwanted history from an
existing company?

Regards,

Michael

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


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
todd Anderson
Sent: Thursday, October 06, 2005 6:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] New Test database

Jasper,

Did it about 4 years ago with a V4 database so yes it can be done.

You'll need the Progress database export/import tools.

Make a list of all master tables in Vantage. Like - customer, vendor, part,
salesperson, etc. Then sequence them as either prime tables or secondary
tables. Prime tables would be vendor, part, customer, etc. Secondary
tables would be tables like salesperson which provide entries that can be
used in the prime tables.

Then export all of the tables you need. Setup the new database and
configure the company info as required. (You can load any of the master
tables that you exported into Access if you want to trim them to active only
entries or ??? In our case we exported the parts/bom info and then trimmed
out all items that had not been used in the last 2 years which reduced the
size by 60-70%.)

When you load the data into the new database - load the minor, secondary
tables first. So before you load the customer table make sure you load the
salespeople minor table first otherwise the customer table will have entries
that don't match.

We pulled over basically all of the master tables having trimmed out the
junk we didn't need.

This isn't hard to do. It is tedious. You have to map out and sequence the
tables carefully.

As I recollect it took me a couple of weeks to figure it out and make the
transfer. Reloading the info by hand would have taken 1 yr+ in man-months
so it made sense to do it.

New database was very small and we trimmed out 90% of the old crap in the
process.

Todd Anderson




_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Thursday, October 06, 2005 7:25 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] New Test database


Is there a way to create a new database but import all our parts list and
vendors but with NO Sales orders, PO's and Jobs.

Is there an easy way to do this?

Thanks,
Jasper


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



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



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.


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



------------------------ Yahoo! Groups Sponsor --------------------~--> Fair
play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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