Alfresco database migration

[vipul_nimbale]

Hi All,

I am migrating the Alfresco 4.1.x from one server to another server on Windows. I have copied all content stores from source server to destination server.

I getting the issue while initializing the database. I installed Alfresco version 4.1.x version on my machine . given the path of content direct in alfresco.properties path for content root directory.

When I start the server it creates the database but not inserting data related to my old content. I am expecting data for my Old content too. but I am not seeing any details of my content.

I can I copy old db data to new DB sever. I am using MS SQL server I am using import and export wizard of SQL server

But getting issue of foreign key constraint.

Can any body suggest how can I export Old database into new database.

Please Help.

[kintu_barot]

First, you should take the dump of your source server database.

Then on the destination server, you should restore that dump into the destination database before first time starting the server. So when you will start the server it will have all the references of the content available from the database.

If you have further query please let me know.

Regards,

Kintu

ContCentric