Hello, I need some help!!! What are the steps to follow for database installation on a different server??? Must I to execute the db_setup.bat in the database server??? I appreciate your help!!!
Create a new, blank schema/database/wotnot in the database called "alfresco"
Create a new user/login in the database also called "alfresco" and with password "alfresco", and grant that user full access to the "alfresco" schema/database/wotnot created in step 1
Configure Alfresco with the coordinates and Hibernate dialect for the database
Restart Alfresco
The first time it starts Alfresco will detect that the database is blank and create all of its tables and populate them with a small amount of initial "bootstrap" data. Once that process is complete you're done!
Note: if you're trying to migrate an existing, populated Alfresco database from one server to another then the process is a little different: basically you would need to copy the Alfresco database from the old server to the new server, then follow steps 3 and 4 above. How to perform the copying varies from database vendor to database vendor, but most databases include tools to do this so you should be able to find out more in your database's documentation.
