In case of a new update of YGOPro I will lost all the information of my Custom cards in the cards.cdb, and I don't want to add them one per one in the new cards.cdb.

Is there other method to add faster the cards to the cards.cdb?

The way I chose to do it is with these sql queries



First, when you get a new ygopro version, rename your old card.cdb file to "old.cdb"

Then save the above query to a file called "insert.sql", and save it to your ygopro folder, then create another file called "addcards.bat" with the following contents and save it to your ygopro folder.



Next download sqlite  and place the file in your ygopro folder.

Finally, move the new ygopro files into the folder, then run addcards.bat.

If that's too complicated for you, you can instead use Outlaw's Card Manager or my Card Packer (link in the sig) to create a .zip file of custom cards you use to later re-import them after an update.

---

The way I chose to do it is with these sql queries

ATTACH "old.cdb" AS old;
INSERT INTO datas SELECT old.datas.id,old.datas.ot,old.datas.alias,old.datas.setcode,old.datas.type,old.datas.atk,old.datas.def,old.datas.level,old.datas.race,old.datas.attribute,old.datas.category FROM old.datas LEFT JOIN  datas ON main.datas.id=old.datas.id WHERE main.datas.id IS NULL;
INSERT INTO texts SELECT old.texts.id,old.texts.name,old.texts.desc,old.texts.str1,old.texts.str2,old.texts.str3,old.texts.str4,old.texts.str5,old.texts.str6,old.texts.str7,old.texts.str8,old.texts.str9,old.texts.str10,old.texts.str11,old.texts.str12,old.texts.str13,old.texts.str14,old.texts.str15,old.texts.str16 FROM old.texts LEFT JOIN texts ON main.texts.id=old.texts.id WHERE main.texts.id IS NULL;

First, when you get a new ygopro version, rename your old card.cdb file to "old.cdb"

Then save the above query to a file called "insert.sql", and save it to your ygopro folder, then create another file called "addcards.bat" with the following contents and save it to your ygopro folder.

sqlite3 cards.cdb ".read insert.sql"

Next download sqlite  and place the file in your ygopro folder.

Finally, move the new ygopro files into the folder, then run addcards.bat.

Lets me try

The way I chose to do it is with these sql queries

ATTACH "old.cdb" AS old;
INSERT INTO datas SELECT old.datas.id,old.datas.ot,old.datas.alias,old.datas.setcode,old.datas.type,old.datas.atk,old.datas.def,old.datas.level,old.datas.race,old.datas.attribute,old.datas.category FROM old.datas LEFT JOIN  datas ON main.datas.id=old.datas.id WHERE main.datas.id IS NULL;
INSERT INTO texts SELECT old.texts.id,old.texts.name,old.texts.desc,old.texts.str1,old.texts.str2,old.texts.str3,old.texts.str4,old.texts.str5,old.texts.str6,old.texts.str7,old.texts.str8,old.texts.str9,old.texts.str10,old.texts.str11,old.texts.str12,old.texts.str13,old.texts.str14,old.texts.str15,old.texts.str16 FROM old.texts LEFT JOIN texts ON main.texts.id=old.texts.id WHERE main.texts.id IS NULL;

First, when you get a new ygopro version, rename your old card.cdb file to "old.cdb"

Then save the above query to a file called "insert.sql", and save it to your ygopro folder, then create another file called "addcards.bat" with the following contents and save it to your ygopro folder.

sqlite3 cards.cdb ".read insert.sql"

Next download sqlite  and place the file in your ygopro folder.

Finally, move the new ygopro files into the folder, then run addcards.bat.

Thanks Vertex, Works perfecty!