PatrickChua: Restore Axapta database

[Blog bot]

Источник: http://PatrickChuaAx.spaces.live.com...68AA!114.entry
==============
Today I've tried to restore a backup of the current development environment to the laptop. Below is the procedures.
 
 
1.  Copy the entire application folder to your local appl folder
Ex: SP5CMBTEST
    Locate the source directory in bportal
   \bportal\axapta$\AX30SP5\APPL\ THEN CHOOSE THE version to copy
   ex.SP5CMDDEV
  \bportal\axapta$\AX30SP5\APPL\SP5CMBDEV
 
 COPY AND PASTE TO THE LOCAL DIRECTORY
 C:\Documents and settings\All Users\Application Data\Navision\Axapta Application
 Which can be found in the axapta configuration utility, system directory.
 

1. Create a database in SQL Server SP5CMBTEST

 
A.      backup first the bportal
B.      locate this backup
C.      copy to local c:\devbak\SP5CMBTEST
D.      restore devbak\SP5CMBTEST to SQLSERVER in a new database named
 
      SP5CMDTEST
 
 
FORCE  RESTORE
 

1. Restore the database to SP5CMBTEST

 

1. Create a Log-In SP5CMBTEST, pls see how databases are configured properly

   

1. 1. goto sql enterprise manager
   2. goto security
   3. create a user SP5CMBTEST
   4. click databaseaccess tab, CLICK SP5CMBDEV, CLICK DB_OWNER
   5. CLICK MASTER, click public
   6. Click server roles tab
   7. Click all server role
   8. Click general tab
   9. Click Sql Server authentication
   10. Enter password   (bmssa)
   11. Verify Password (bmssa)

 

1. Create a configuration, make sure it point to application, database, user as SP5CMBTEST

 

1. 1. Launch configuration file
   2. Choose the original configuration pointing to local directory
   3. Click manage configuration
   4. Click new configuration
   5. Type SP5CMBDEV
   6. CLICK SQL SERVER TAB
   7. Click database choose from dropdown list SP5CMBDEV
   8. Click database user id, TYPE SP5CMBDEV
   9. Click Database Password
   10. Click Use this password
   11. Enter bmssa in password
   12. Enter bmssa in confirm
   13. Click apply
   14. CLICK GENERAL TAB
   15. CLICK APPLICATION choose from dropdown SP5CMBDEV
   16. CLICK EXPORT
   17. LOCATE THE APPLICATION DIRECTORY IN DRIVE C , THIS WILL COPIED TO THE DIRECTORY

     IN C:\PROGRAM FILES\NAVISION\AXAPT CLIENTS\BIN
WHICH IS FOUND IN THE CONFIGURATION FILE GENERAL TAB  ALT.BIN DIRECTORY
 

1. Create a shortcut pointing to SP5CMBTEST

           Locate the appl folder in local drive
           C:\documents and settings\all users\application data\navision\axapta  
           application\appl\SP5CMBDEV

 
To verify if restore is complete
       Login in axapta, then look for latest data window with latest fields in form
      Examine also in aot  latest codes/classes, etc.
 
 



==============
Источник: http://PatrickChuaAx.spaces.live.com...68AA!114.entry