TUTORIAL: How to Convert FIFA 19 Database to FIFA 16

rique1984

Reserves
THIS IS A TUTORIAL ON HOW TO CONVERT FIFA 19 DATABASES AND SQUAD UPDATES TO FIFA 16.

TOOLS NEEDED:

DBMASTER 16
CREATION MASTER 16
MS EXCEL
FIFA 19 Saved Squads DB Tool

In order to successfully convert the FIFA 19 database to FIFA 16 the above tools are necessary. Firstly, you need to get a clean unmodded FIFA 16 database and a FIFA 19 database. There are specific tables that need to be converted. Not all tables need to bo converted.

Here we go:

Firstly, note the tables that need to be converted. These are:


teamstadiumlinks
teams
teamplayerlinks
teamnationlinks
teamkits
teamballs
starratingboundaries(optional)
stadiums(optional)
shoecolors
rowteamnationlinks
rivals
previousteam
players
playernames
playerloans
playerboots
player_grudgelove
manager
leagueteamlinks
leagues
competition


 
Last edited:

Johnny28ua

Starting XI
THIS IS A TUTORIAL ON HOW TO CONVERT FIFA 19 DATABASES AND SQUAD UPDATES TO FIFA 16.

TOOLS NEEDED:

DBMASTER 16
CREATION MASTER 16
MS EXCEL
Buddy you know how to convert transfers and can do it for FIFA 16?I think for me it will be difficult to make it.And I can test db for you :)
 

rique1984

Reserves
Buddy you know how to convert transfers and can do it for FIFA 16?I think for me it will be difficult to make it.And I can test db for you :)
YEAH, I DO MATE. I AM CONVERTING THE SQUAD UPDATE FROM LAST WEEK.
DOES A NEW FIFA 19 SQUAD UPDATE COME OUT TODAY? FOR THE TUTORIAL
I WILL CONVERT LAST WEEK'S SQUAD AND CONVERT THIS WEEK'S SQUAD
UPDATE TOMORROW.

P.S. YOU CAN TEST THE CONVERTS FOR ME...NO PROBLEM, MATE
 

Johnny28ua

Starting XI
YEAH, I DO MATE. I AM CONVERTING THE SQUAD UPDATE FROM LAST WEEK.
DOES A NEW FIFA 19 SQUAD UPDATE COME OUT TODAY? FOR THE TUTORIAL
I WILL CONVERT LAST WEEK'S SQUAD AND CONVERT THIS WEEK'S SQUAD
UPDATE TOMORROW.

P.S. YOU CAN TEST THE CONVERTS FOR ME...NO PROBLEM, MATE
yes buddy:)
 

rique1984

Reserves
(1) Open both the FIFA 19 database and FIFA 16 database with DB Master 18. Then extract these tables into any folder

Screenshot (52)_0.png


You can extract the specific tables that were listed or choose to extract all tables

(2) Open these tables with MS Excel

Screenshot (100).png


Compare the headings for FIFA 19 tables and FIFA 16 tables. In FIFA 19 there are some tables that are not present in FIFA 16. Delete these tables from FIFA 19 tables.

Screenshot (84).png


In this example...clubworth is in FIFA 19 but not FIFA 16. Delete this entry. You will continue this process in all tables.

***IN SOME INSTANCES TABLES FROM FIFA 19 NEED TO REARRANGED INTO EXCEL TO MATCH WITH THOSE IN FIFA 19.
THE ORDER THE TABLES APPEAR IN MUST BE IDENTICAL FOR THEM TO BE ABLE TO IMPORT THESE TABLES INTO THE FIFA
16 DATABASE.

Screenshot (90).png

Once this is completed, import these edited tables into FIFA 16 default database and everything should be completed.

NB*** SOME TABLES IN FIFA 19 AND FIFA 16 ARE IDENTICAL SUCH AS PLAYERLOANS, PLAYER_GRUDGELOVE AND TEAMBALLS AND STARRATING BOUNDARIES.
YOU CAN SIMPLY IMPORT THESE. HOWEVER, SOME TABLES ARE IDENTICAL BUT NEED TO BE REARRANGED. AN EXAMPLE OF THIS IS ROWTEAMNATIONLINKS. THIS SHOULD BE DONE. IN FIFA 16 THE COLUMN NATIONID IS FIRST AND TEAMID IS SECOND. IN FIFA 19 THIS IS THE OPPOSITE. THIS NEEDS TO BE EDITED TO REFLECT
THIS. SOME ENTRIES IN FIFA 19 MAY ALSO BE HIGHER THAN A CORRESPONDING ENTRY IN FIFA 16. FOR EXAMPLE:

(haircolorcode 13 - red hair - FIFA 16 MAXIMUM VALUE IS 12
facialhairtype 17 (shaved), 16 - (shaved) - IN FIFA 16 MAXIMUM VALUE IS 15
hairtypecode 541 -women hair low - IN FIFA 16 MAXIMUM MAXIMUM VALUE IS 540
bodytypecode 18 - sydney leroux women - IN FIFA 16 MAXIMUM VALUE IS 17)


THESE FILES CAN BE RE-IMPORTED USING DBMASTER 18...
 
Last edited:

Papinho81

Youth Team
Thank you for the tutorial!

What about columns for a specific table that exist in the two versions (19 and 16) but that have values in 19 that do not exist in 16? Example, playertaits in the players.txt table (and many others...)?
 
Top