MTU.Community

MTU.Community (http://forum.mtu.com/index.php)
-   Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)
-   -   unbalanced data bases (http://forum.mtu.com/showthread.php?t=9368)

rontoo October 5th, 2007 07:57 PM

unbalanced data bases
 
I have about 6000 KMA's in one computer and about 5000 in my laptop. Is it possible to combine the two databases in another drive without getting thousands of title duplications. The laptop is full.

ddouglass October 5th, 2007 10:06 PM

How much of the 6,000 and 5,000 are the same files?
I am guessing you are going to move the files to an external hard drive?
If you imported on both machines and didn't pay attention to your BookIDs then you probably have many duplicate IDs which will not rebuild without using the Merge Database. However this will change the duplicate BookID to the next available number. This means you will have to reprint your books to add the new items in.
I would copy the 6,000 to the new drive, then move it to the laptop. There are some utilities that you can use to compare the two drives to eliminate the duplicate files. Then copy the rest from the laptop to the external hard drive. After all of them are joined then do the Merge Database.

billyo October 6th, 2007 03:02 PM

Quote:

Originally Posted by rontoo (Post 66535)
I have about 6000 KMA's in one computer and about 5000 in my laptop. Is it possible to combine the two databases in another drive without getting thousands of title duplications. The laptop is full.


that is what i'm doing now..i have 3 ext. drives hooked-up to my laptop , 2 drives with my kma files and 1 empty..i opened both of my 2 drives and comparing the brand id's..the one drive that has more space is where i put in the new imported songs or brands that i dont have on the other..and then copying them to the empty drive so i could get rid of some of my duplicate songs, ( modify your ext. drives so they will be arrange alphabetically ) it tooks me a while caused i have about 34.000 songs ..or just do what Dale is saying if you dont care about the book id..just merge database..thats what i did the first time..


All times are GMT -4. The time now is 02:37 AM.

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.