I guess the easiest way would in Excel. Just open both DBs in a separate excel and then copy and paste.
Just don't forget to check and fix the IDs. For example each team and cyclist ID (first column) has to be unique across the table. So if you change the team ID, obviously you also have to update it on the cyclist table.
But you have to check every column which starts with fkID, for example the equipment might not be the same in both DBs. And so on...
Thanks Lachi,but this process seems to be too hard for me!
I've tried, but after that I save my file excel modified,what I must do?
I've this error when I try to open db with your editor:
----An error occured----
Impossibile attivare i vincoli. Una o più righe contengono valori che violano il vincolo non-null, unique o foreign-key.
----Stacktrace----
in System.Data.DataTable.EnableConstraints()
in System.Data.DataTable.set_EnforceConstraints(Boolean value)
in System.Data.DataTable.ReadXml(XmlReader reader, Boolean denyResolving)
in System.Data.DataTable.ReadXml(String fileName)
in FoolEditor.DBLoader.LoadDatabase(Object sender, DoWorkEventArgs e)
in System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Some easy help!
Edited by Megas Alexandros on 15-05-2013 01:43
I can only guess but according to the message, a number in one of the fkID columns is either empty or does not match with any of the related IDs (first column of the linked table).
