Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
combine databases
Author Message
DVD Profiler Unlimited Registrantroflmao
to eq or not to wow?
Registered: June 22, 2007
Posts: 42
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Is there a way to join two databases, I maintained two seperate lists before, but now just want it all in one database and listing.  Any help would be appreciated.
Current plan is to export to csv the smaller db, and do a search by title (cant export isbn # - key info, but cant find it.)  Any help would be apprecated.
DVD Profiler Unlimited RegistrantStar Contributorsynnerman
Take me with you. Please.
Registered: March 13, 2007
United States Posts: 736
Posted:
PM this userDirect link to this postReply with quote
I believe the easiest way to do it would be:

1. Backup one of the lists (using the "Backup Database" feature).
2. Open the other list.
3. Use the Restore Database feature to select this new backup, but DO NOT "Restore All Profiles" (since I believe it will overwrite the existing list).  Instead, select "Restore Specific Profiles", then Select All.  You can then restore those profiles.
 Last edited: by synnerman
DVD Profiler Unlimited RegistrantStar ContributorJimmy S
Registered: March 15, 2007
Canada Posts: 1,982
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
You just have to backup one of the database and choose what you want to keep. Since it's a complete backup I suppose that you want to keep everything.



After restore the database in the other one.



Just in case do a backup of the other too, normally this is the procedure but it's better to be safe in case of a problem happen.

Edit : Synner_man answer in the same that I did, but I let my answer with the picture
DVD Profiler Unlimited RegistrantStar Contributor?
?
Registered: March 14, 2007
Posts: 3,830
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
nice job both
Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions.
DVD Profiler Desktop and Mobile Registrantpauls42
Reg: 31/01/2003
Registered: March 13, 2007
United Kingdom Posts: 2,692
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting AESP_pres:
Quote:
You just have to backup one of the database and choose what you want to keep. Since it's a complete backup I suppose that you want to keep everything.



After restore the database in the other one.



Just in case do a backup of the other too, normally this is the procedure but it's better to be safe in case of a problem happen.

Edit : Synner_man answer in the same that I did, but I let my answer with the picture


as an addition - you should select "Restore specific profiles - and then select all" rather than select all at the top of the screen
Paul
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting synner_man:
Quote:
1. Backup one of the lists (using the "Backup Database" feature).

Small addition: Backup both lists, just to be on the safe side. 

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next