Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Migrate database from 8.2 to 9.1

(0) ShareShare
ReportReport
Posted on by 80

Hello!

Just got on new job in IT company. There are exist production 8.2 instance and test 9.1 instance on another computer

Test instance already have modified scripts and views for new version and use SQL backup from july.

How the best to migrate new data (opportunities, orders) from 8.2 to 9.1 and be sure that:

1. Only sales data will migrate (scripts and views will stay as it already in test instance)

2. Data integrity will be 100%

Thank you for any advice

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Migrate database from 8.2 to 9.1

    Hello,

    It's not possible to bring the data-only using OOB tools. You will have to develop a set of scripts to migrate the data. My recommendation is to use SSIS packages with KingsWaySoft adapters.

    Good luck.

  • Evgenich Profile Picture
    Evgenich 80 on at
    RE: Migrate database from 8.2 to 9.1

    Hi,

    Yes, need to move existing 8.2 production DB in new instance but make sure that views and scripts from 9.1 stay untouched

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Migrate database from 8.2 to 9.1

    Hello,

    I'm not sure - do you want to use the existing 8.2 db in your 9.1 instance or do you want to migrate part of the data from 8.2 to 9.1?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans