Copy parts form one DB to another?

Yahoo Archive
1
There is a simple method if you are comfortable with doing a dump and load and know the tables well enough to know which ones to keep and which ones not to. I have done this several times:

Dump the data from both databases.
Copy the text files from the source dump folder to the destination dump folder.
Reload and index the data.

You just have to make sure you copy the correct tables. Our database is almost 4 gig and I can do a full dump and load in about 45 minutes. Of course, I already have a blank database with the definitions ready to start with (saved this from the 1st time I did the dump and load).



----- Original Message -----
From: corvette6672
To: vantage@yahoogroups.com
Sent: Monday, October 13, 2008 2:50 PM
Subject: [Vantage] Copy parts form one DB to another?


We are doing some testing on the pilot and test databases with version
406. Is there an easy way to remove all transactions from a database,
yet retain all the parts and their methods?

Or can multiple parts and their methods be copied from one DB to
another blank database easily?





[Non-text portions of this message have been removed]
2
We are doing some testing on the pilot and test databases with version
406. Is there an easy way to remove all transactions from a database,
yet retain all the parts and their methods?

Or can multiple parts and their methods be copied from one DB to
another blank database easily?
3
We are in 8.03.305 and there is no inherent functionality that lets you copy
data between databases. I already asked !!

We use ServiceConnect and store test data in spreadsheets initially, and
then we can load them to which ever database takes our fancy...

It works a treat...

Thanks,

Nick

_____

From: corvette6672 [mailto:corvette6672@...]
Sent: 13 October 2008 20:50
To: vantage@yahoogroups.com
Subject: [Vantage] Copy parts form one DB to another?



We are doing some testing on the pilot and test databases with version
406. Is there an easy way to remove all transactions from a database,
yet retain all the parts and their methods?

Or can multiple parts and their methods be copied from one DB to
another blank database easily?





This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246-451701.


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