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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Split Multi-Company Da...
Microsoft Dynamics AX (Archived)

Split Multi-Company Database

(0) ShareShare
ReportReport
Posted on by Simon_M 80

I have a multi-company Axapta system in one production database.

 I want to split off one company to a new Axapta server and seperate database.

Have tried to export the company on original system to dat and def files and import on the new server and SQL database, but there is alot of baisc data missing when this is done (number sequences, item types, units, units conversions, etc, etc)

 Can anyone suggest a method to extract a single company from a multi-company database and establish this extracted data on a new server intact???

*This post is locked for comments

I have the same question (0)
  • MohammedRasheed Profile Picture
    MohammedRasheed 1,405 on at
    Hi Simon, give this a try.. calling ur environment liveOld and liveNew. also before you begin, make sure that there are no intercompany dependencies or virtual companies the company you want to split is associated with. Also its important that the application (atleast the Data Dictionary) is the same on LiveOld and LiveNew. 1. Back up everything..liveNew and liveOld.. 2. shut down liveOld (this is me being paranoid.. but i rather be safe than sorry). 3. on liveNew open the Company Accounts form (Administration > Company Accounts) 4. create the company account you want to 'Split' from liveOld (if it doesn't already exist) - make sure its the same name/id as liveOld. 5. select the company account and then click on Restore 6. specify the Server and the DB that host the liveOld DB. 7. hit ok .. and give it time.. 8. after its done.. restart ax.. and synchronize (paranoid me). 9. check if everything is ok.. 10. start liveOld 11. later you might want to delete the company from liveOld.. but i would suggest doing it only after (backing up and) running liveNew for a few weeks. hope this helps. let us know if you need any more help. regards, Mohammed Rasheed www.dynamic-ax.co.uk
  • Kusnadi Lim Profile Picture
    Kusnadi Lim 365 on at

    Dear Simon;

     A simplest way is to backup the database, then you should do :

    1. take the backup database and restore it as new database name.

    2. install a new AOS server to workwith new created database

    3. configure your client to access the new AOS created.

    4. run your ax and you will see the exact copy from previous

    5. go to admin>company, duplicate the company name you want to split, and after that delete all remaining company except DAT

  • MohammedRasheed Profile Picture
    MohammedRasheed 1,405 on at

     

    Cheers Kusanadi!!. you are correct..

    its sometimes hard to find elegance in simplicity..

    my bad :(

     

  • Simon_M Profile Picture
    Simon_M 80 on at

    Guys

     Thankyou for your suggestions i appreciate the advice.

     Does the fact that the original installation was on Sql 2000 and the new system is on SQL 2005 make any difference to your advice?

     Regards

    Simon 

  • MohammedRasheed Profile Picture
    MohammedRasheed 1,405 on at

    Hi Simon,

    No. the procedure would still be the same.

    Just remember to test your New Environment thoroughly.

    Sql server automatically updates the object model when you restore from a previous version.

    so fist back up the live db (2000) and restore on to (2005)... then copy paste the appl on to a new folder.. install a new aos and point appropriate to the TestDb (2005) and testAppl..

    Synchronise the DD..

    if i remember correctly we tried doing this once .. and noticed minor performance issues on the new environment.... on further investigation we found that the DB was set to work in Sql 2000 compatibility.. which we later changed.. Dont think it will be an issue with what ur tying to do.. but keep an eye out for it.

    regards,

    Mohammed

     

     

  • Simon_M Profile Picture
    Simon_M 80 on at

    Guys Thanks once again, we now have a working Test Environment.

    I have one more question

    We are left with just the one company we wanted to split off and so far appears to be working well as we go through our testsing.

     The new company though has reatined all the users and user groups for all the other Axapta companies, never had to do it before - is their a way to delete the unwanted user groups?

     Simon

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans