topic Alfresco database migration in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-database-migration/m-p/94718#M27940 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P>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.</P><P>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.</P><P></P><P>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</P><P></P><P>But getting issue of foreign key constraint.</P><P></P><P>Can any body suggest how can I export Old database into new database.</P><P></P><P>Please Help.</P></BODY></HTML> Sun, 04 Aug 2019 11:47:49 GMT vipul_nimbale1 2019-08-04T11:47:49Z Alfresco database migration https://connect.hyland.com/t5/alfresco-forum/alfresco-database-migration/m-p/94718#M27940 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 d Sun, 04 Aug 2019 11:47:49 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-database-migration/m-p/94718#M27940 vipul_nimbale1 2019-08-04T11:47:49Z Re: Alfresco database migration https://connect.hyland.com/t5/alfresco-forum/alfresco-database-migration/m-p/94719#M27941 <HTML><HEAD></HEAD><BODY><P>First, you should take the dump of your source server database.</P><P>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.</P><P></P><P>If you have further query please let me know.</P><P></P><P>Regards,</P><P>Kintu</P><P><A href="http://www.contcentric.com" rel="nofollow noopener noreferrer">ContCentric</A></P></BODY></HTML> Tue, 06 Aug 2019 05:37:47 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-database-migration/m-p/94719#M27941 kintu_barot 2019-08-06T05:37:47Z