Extension Objects names in SQL table names diffences

(0) Share

Report

Posted on by Hafiz@d365

Hi,

I have custom objects in Business central since I want to create an extension in the Business Central cloud I have renamed object names with BGS_ as a suffix in Visual Studio code and Published them online but my SQL server database tables are without Suffix BGS_. So data from these tables are not copied into my online business central.

will you suggest one? Please

I have the same question (0)

All responses (9)

Answers (1)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

The extension that is installed in OnPrem and Cloud should be the same.

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

Yes, Mohana,

I am aware of the issue. Please give me a solution. I

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Please install the app with BGS_ in OnPrem database also and try to migrate afterwards.

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

Things get more complicated

when I want to deploy an extension on the promise, the allowed object ranges differ. cloud objects ranges I have done are different.

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (1)

Report

You can define the table mappings in the latest Cloud Migration Tool.

Please try this

learn.microsoft.com/.../migration-table-mapping

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

Hi Mohana,

Your advice is working fine.

around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.

example

"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'

where to correct

I have increased the size as shown below

modify(Description)

{

Width = 500;

}

in the 'Item' table

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

Hi Mohana,

Your advice is working fine.

around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.

example

"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'

where to correct

I have increased the size as shown below

modify(Description)

{

Width = 500;

}

in the 'Item' table

Was this reply helpful? Yes No
Hafiz@d365 13 on at

Like (0)

Report

Hi Mohana,

Your advice is working fine.

around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.

example

"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'

where to correct

I have increased the size as shown below

modify(Description)

{

Width = 500;

}

in the 'Item' table

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Width property is different to length of the field.

We cannot increase the length of the field size in BC.

Standard Description field length is 100 characters so you have to shrink your data in description field 100 in your OnPrem system.

Was this reply helpful? Yes No