Migrate MSSQL websi...
 
Notifications
Clear all

Migrate MSSQL website panel to solidcp

18 Posts
3 Users
0 Reactions
3,342 Views
Posts: 43
Topic starter
(@nocnet)
Eminent Member
Joined: 8 years ago

Hi,

I have complete setup new solidcp. From link https://solidcp.com/kb/installation/migrate-websitepanel-solidcp/ said i need to copy from DATA folder. But when i copy and paste at new server, MSSQL service cannot be up. Is there any other way i can extract data from old db website panel to new db solidcp?

Thanks

17 Replies
Posts: 43
Topic starter
(@nocnet)
Eminent Member
Joined: 8 years ago

Is there anyway to import configuration from website panel to solidcp?

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hi,

 

You will need to move the database form the Websitepanel to SolidCP database with the update_sql.sql as explained in https://solidcp.com/kb/installation/migrate-websitepanel-solidcp/

 

Kind Regards,

 

Trevor Robinson

Reply
Posts: 43
Topic starter
(@nocnet)
Eminent Member
Joined: 8 years ago

From your link:

Migrating from WebsitePanel Enterprise Server to SolidCP is relatively straight forward:

  1. Delete all contents of your current WebsitePanel Enterprise (default path: c:WebsitePanelEnterprise Server)
  2. Once the Enterprise directory is empty you can copy and paste all files from the SolidCP Enterprise zip file into the WebsitePanel Enterprise Server folder.
  3. Load up the WebsitePanel Enterprise backup --> and check out it's web.config
  4. find whats between the 'connectionStrings' and copy it over to the new SolidCP Enterprise server web.config AND in the enterprise/bin/SolidCP.SchedulerService.exe.config
  5. find the "WebsitePanel.CryptoKey" where you copy whats inbetween the value=" " and put it in the new SolidCP enterprise server web.config AND in the enterprise/bin/SolidCP.SchedulerService.exe.config
  6. Load up SQL Management --> go to the WebsitePanel database --> right click and select "New query"
  7. Open the update_sql.sql from the SolidCP Enterprise update zip, remove the first 2 lines and paste it in the "New Query"
  8. Click execute and double check it completed successfully.
  9. To add the SolidCP Scheduler service open up CMD (or powershell --> cmd) and execute:
    sc.exe create "SolidCP Scheduler" binPath= "C:WebsitePanelEnterprise ServerbinSolidCP.SchedulerService.exe" DisplayName= "SolidCP Scheduler" start= auto

    Once executed succesfull it should state "[SC] CreateService SUCCESS"

  10. Load up IIS Management and go to the WebsitePanel Enterprise website.
  11. Go to authentication and Disable Windows authentication if available.
  12. In the WebsitePanel Enterprise site go to Machine Key --> at the right side bar click generate, then apply.
  13. Double check if the binding is still correct as before.

Thats all there's to it, your WebsitePanel Enterprise site is now converted to the new SolidCP Enterprise!

I'm confuse with no 1 and no 2. Is this correct? Old server using website panel and new server using solidcp. Why need to delete from old server?? Please explain to me so i understand.

Reply
Posts: 43
Topic starter
(@nocnet)
Eminent Member
Joined: 8 years ago

From your link:

Migrating from WebsitePanel Enterprise Server to SolidCP is relatively straight forward:

  1. Delete all contents of your current WebsitePanel Enterprise (default path: c:WebsitePanelEnterprise Server)
  2. Once the Enterprise directory is empty you can copy and paste all files from the SolidCP Enterprise zip file into the WebsitePanel Enterprise Server folder.
  3. Load up the WebsitePanel Enterprise backup --> and check out it's web.config
  4. find whats between the 'connectionStrings' and copy it over to the new SolidCP Enterprise server web.config AND in the enterprise/bin/SolidCP.SchedulerService.exe.config
  5. find the "WebsitePanel.CryptoKey" where you copy whats inbetween the value=" " and put it in the new SolidCP enterprise server web.config AND in the enterprise/bin/SolidCP.SchedulerService.exe.config
  6. Load up SQL Management --> go to the WebsitePanel database --> right click and select "New query"
  7. Open the update_sql.sql from the SolidCP Enterprise update zip, remove the first 2 lines and paste it in the "New Query"
  8. Click execute and double check it completed successfully.
  9. To add the SolidCP Scheduler service open up CMD (or powershell --> cmd) and execute:
    sc.exe create "SolidCP Scheduler" binPath= "C:WebsitePanelEnterprise ServerbinSolidCP.SchedulerService.exe" DisplayName= "SolidCP Scheduler" start= auto

    Once executed succesfull it should state "[SC] CreateService SUCCESS"

  10. Load up IIS Management and go to the WebsitePanel Enterprise website.
  11. Go to authentication and Disable Windows authentication if available.
  12. In the WebsitePanel Enterprise site go to Machine Key --> at the right side bar click generate, then apply.
  13. Double check if the binding is still correct as before.

Thats all there's to it, your WebsitePanel Enterprise site is now converted to the new SolidCP Enterprise!

I'm confuse with no 1 and no 2. Is this correct? Old server using website panel and new server using solidcp. Why need to delete from old server?? Please explain to me so i understand.

Reply
Page 1 / 4
Share: