let me complete the comments:
first of all, you have done all on BC 14. you must transfer all data from the customized fields to extension and after upgrading all to extension you may upgrade to BC 15 version.
- Create a table with the name of "Customer UPG" in the development environment of Business Central 14
- create an upgrade code-unit and written code DataUpgradeMgt.SetTableSyncSetup(DATABASE::"Customer",DATABASE::"Customer UPG",TableSynchSetup.Mode::Move);
- replace the Customer table with the original one (from CRONUS objects) and sync with Forcesync.
- By doing the above field deleted from Customer and data moved to the Customer UPG Table.
- installed the extension which has the Customer table extension with the customized field.
- go to the installation folder of BC 14, run command prompt as administrator and run the following command:
finsql.exe Command=generatesymbolreference, Database=<DatebaseName>, ServerName=<ServerName>\<Instance>
When you run the command, the console returns to an empty command prompt, and does not display or provide any indication about the status of the run. However, the finsql.exe may still be running in the background. It can take several minutes for the run to complete, and the symbols will not be generated until such time. You can see whether the finsql.exe is still running by using Task Manager and looking on the Details tab for finsql.exe.
When the process ends, a file named navcommandresult.txt is saved to the Dynamics NAV Client connected to the Business Central installation folder. If the command succeeded, the file will contain text like [0] [06/12/17 14:36:17] The command completed successfully in '177' seconds.
- on VisualCode, create a new project with the name of "Upgrade Data". connect to BC 14 and download the symbol.
now you have "Customer UPG" on the symbols.
do not forget to make the dependency on this project with your extension app to make sure you have the customized field on extension before transferring the data
- create the following code unit in "Upgrade Data" project:
codeunit 51001 DataInstall_E
{
Subtype = Install;
trigger OnInstallAppPerCompany();
var
begin
TransferDataInsert(<Cutomer UPG table ID>, <Customer Table ID>);
end;
procedure TransferData(TableFromID : Integer;TableToID : Integer);
var
Field : Record Field;
RecRefFrom : RecordRef;
RecRefTo : RecordRef;
FieldRefFrom : FieldRef;
FieldRefTo : FieldRef;
begin
CLEAR(RecRefFrom);
CLEAR(RecRefTo);
Field.RESET();
RecRefFrom.OPEN(TableFromID);
RecRefTo.OPEN(TableToID);
IF RecRefFrom.FINDSET() THEN BEGIN
Field.SETRANGE(TableNo,TableFromID);
REPEAT
IF Field.FINDSET() THEN BEGIN
RecRefTo.INIT();
REPEAT
FieldRefFrom := RecRefFrom.FIELD(Field."No.");
FieldRefTo := RecRefTo.FIELD(Field."No.");
FieldRefTo.VALUE(FieldRefFrom.VALUE());
UNTIL Field.NEXT() = 0;
IF RecRefTo.INSERT() THEN;
END;
UNTIL RecRefFrom.NEXT() = 0;
END;
end;
}