Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Data Migration with Attachments

(0) ShareShare
ReportReport
Posted on by 415

Hi all,

I'm migrating an old c company to a new database,

Is it possible to import old history(posted purchase/sales invoices), with the attachments that they were originally posted with

Thanks

  • Suggested answer
    JAngle Profile Picture
    33,135 on at
    RE: Data Migration with Attachments

    Had a similar circumstance with a client wanting to move notes from NAV to BC SaaS. This required development to achieve. I’d suggest the same here

  • marley milo Profile Picture
    415 on at
    RE: Data Migration with Attachments

    Thanks, I have been trying all sorts, but gathering from what you say, this is not as standard, it would need some dev work to make this possible?

  • Suggested answer
    JAngle Profile Picture
    33,135 on at
    RE: Data Migration with Attachments

    Attachments are stored in blob fields and are therefore binary data. If the configuration package idea is to work you’d need to avoid excel. Export the package so you have a rapid start file. Data dependency will be on the posted data so post some before trying to apply the data in a new company.

    I think an approach similar to the item image import would be needed - just in reverse. This would be custom though.

  • ew9800 Profile Picture
    180 on at
    RE: Data Migration with Attachments

    Try searching for "attachment" tables in your configuration package. Add them to your config pack, export them and then check if you see any relevant data to your "test" attachment. Then try importing to your new database.

  • marley milo Profile Picture
    415 on at
    RE: Data Migration with Attachments

    Thanks, this company is moving to a new tenant, so copy company wont work, it has to be from scratch using config templates, I can't see how I could include original attachments

  • Suggested answer
    ew9800 Profile Picture
    180 on at
    RE: Data Migration with Attachments

    I don't know for sure but when copying a company, the attachments do remain intact so I would expect them to be included with your database migration The only way to know for sure is to test it. As an aside, Notes do not make it over when copying a company.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

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

Featured topics

Product updates

Dynamics 365 release plans