28.10.2006, 18:14
|
#1
|
Участник
|
PatrickChua: Restore Axapta database
Источник: 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.
- 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
- Restore the database to SP5CMBTEST
- Create a Log-In SP5CMBTEST, pls see how databases are configured properly
- goto sql enterprise manager
- goto security
- create a user SP5CMBTEST
- click databaseaccess tab, CLICK SP5CMBDEV, CLICK DB_OWNER
- CLICK MASTER, click public
- Click server roles tab
- Click all server role
- Click general tab
- Click Sql Server authentication
- Enter password (bmssa)
- Verify Password (bmssa)
- Create a configuration, make sure it point to application, database, user as SP5CMBTEST
- Launch configuration file
- Choose the original configuration pointing to local directory
- Click manage configuration
- Click new configuration
- Type SP5CMBDEV
- CLICK SQL SERVER TAB
- Click database choose from dropdown list SP5CMBDEV
- Click database user id, TYPE SP5CMBDEV
- Click Database Password
- Click Use this password
- Enter bmssa in password
- Enter bmssa in confirm
- Click apply
- CLICK GENERAL TAB
- CLICK APPLICATION choose from dropdown SP5CMBDEV
- CLICK EXPORT
- 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
- 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
|
|