web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Extension Objects name...
Small and medium business | Business Central, N...
Answered

Extension Objects names in SQL table names diffences

(0) ShareShare
ReportReport
Posted on by Hafiz@d365 23

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)
  • Mohana Yadav Profile Picture
    Mohana Yadav 61,180 Super User 2026 Season 1 on at

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

  • Hafiz@d365 Profile Picture
    Hafiz@d365 23 on at

    Yes, Mohana,

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

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,180 Super User 2026 Season 1 on at

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

  • Hafiz@d365 Profile Picture
    Hafiz@d365 23 on at

    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.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,180 Super User 2026 Season 1 on at

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

    Please try this

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

  • Hafiz@d365 Profile Picture
    Hafiz@d365 23 on at

    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'.'

    ERoorBCCommunitySupport.jpg

    where to correct 

    I have increased the size as shown below

    modify(Description)
            {
                Width = 500;
            }
    in the 'Item' table
  • Hafiz@d365 Profile Picture
    Hafiz@d365 23 on at

    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'.'

    8081.ERoorBCCommunitySupport.jpg

    where to correct 

    I have increased the size as shown below

    modify(Description)
            {
                Width = 500;
            }
    in the 'Item' table
  • Hafiz@d365 Profile Picture
    Hafiz@d365 23 on at

    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'.'

    5025.ERoorBCCommunitySupport.jpg

    where to correct 

    I have increased the size as shown below

    modify(Description)
            {
                Width = 500;
            }
    in the 'Item' table
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,180 Super User 2026 Season 1 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,964 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,086 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,039 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans