|
Possible to merge Databases
|
| themanxtrain1 |
Posted on 23-06-2015 00:03
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Is it possible to merge to databases together ?? |
| |
|
|
| Jesleyh |
Posted on 23-06-2015 00:27
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Not really, it is a very hard thing to do.
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| themanxtrain1 |
Posted on 23-06-2015 15:46
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Ok thanks |
| |
|
|
| coolrex |
Posted on 23-06-2015 17:31
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
it's possible, but you need a lot of work in the excel editor.
but if you just wanna convert 14 to 15 then it's easier to do |
| |
|
|
| Ad Bot |
Posted on 23-11-2024 17:37
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| themanxtrain1 |
Posted on 23-06-2015 21:16
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
I've done a database with the British teams and some british riders and if i wanted to merge that with somebody elses database so i don't lose what i have done. |
| |
|
|
| Lachi |
Posted on 23-06-2015 21:45
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
That should be possible.
If you have Microsoft Excel, then open both databases in Excel and copy teams, riders (and contracts) to the other database.
You have to pay attention to these things:
1. Don't make and duplicate IDs. You have to make sure that the number in the first column has not been used in the other database yet.
2. Don't make duplicate riders. Only copy the riders which are not in the other database. If they are in the other DB already, change fkIDteam and the contracts instead.
3. Check all the fk-Columns. If the two databases are not based on the same original database, then the numbers in the fk-columns might not match. Example: fkIDsponsor 1 could be Movistar in one DB and Astana in the other DB.
To work in Excel, you could use my Excel Editor |
| |
|
|
| themanxtrain1 |
Posted on 24-06-2015 00:59
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Already using your editor will it work in open office ?? |
| |
|
|
| Lachi |
Posted on 24-06-2015 13:03
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I doubt that it works with open office.
You can try this iwth open office:
1. Download the editor from Cyanide
2. Extract the database
3. Go into the sub-folder of the editor and open the XML files with Open Office
4. Do you editing
5. Save from Open Office back to XML
6. Build new CDB in the editor
Of course you should test steps 5 and 6 before you waste hours of editing |
| |
|
|
| themanxtrain1 |
Posted on 24-06-2015 13:29
|
Free Agent
Posts: 136
Joined: 05-07-2012
PCM$: 200.00
|
Ok thanks will try thanks for the help |
| |
|
