- Create A DB On the Remote Server
- Add Right Portal Alias to the local db with the help DotNetNuke CMS
- Upload Installation files with the FTP Client
- Copy Schema with Sql compare
- Copy Data With Sql Data Compare
- Manually Copy the PortalLocalisation Records
- Change the connectionString of the Website and test
1> Create the DB with your Control panel create a user on the same
2> Add Portal Alias with the Help of Host Account in DotNetnuke CMS Admin >> Site Settings >> Advance Settings >> Add new portal Alias
3> Connect your website with the help of FTP and Upload All files then go on and delete the files from Remote Server Portals\0\Cache\Modules\
4> Copy Schema With Sql Compare
5> Copy Data With SQL Compare
(You can restore the backup on your server if you know how to do it but to save time you can use sql compare)
(Also to use SQL Compare your remote sql server port should be open)
5> Manually Copy the Records In PortalLocalisation Table And Any Other table Which is Failed in SQL Data Compare
7> Change the connection String And Walla you are good to go
