Difference between revisions of "Seamlessly Change Hosting to Hostek.com"
(→MSSQL) |
|||
(28 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | == | + | ==Steps to Changing Hosting Providers== |
− | + | # [https://wiki.hostek.com/Changing_Hosting_Providers#Sign_up_for_hosting Sign up with Hostek.com] | |
+ | # <b>Transfer your site files and databases.</b> Specific details for moving to: [https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_Shared_Hosting Shared Hosting] <b>or </b>[https://wiki.hostek.com/Changing_Hosting_Providers#your-provider_to_Hostek.com_Windows_VPS VPS Hosting] | ||
+ | # [https://wiki.hostek.com/Changing_Hosting_Providers#Planning_Ahead Test your site(s)] | ||
+ | # [https://wiki.hostek.com/DNS_(Name_Servers) Update Your Domain Name's Name Servers] <b>NOTE:</b> you will find the Name Server information in the New Hosting Account Email. | ||
− | ' | + | ==Planning Ahead== |
+ | *Transferring hosting companies can be, and should be, easy if you follow the right steps and choose the right hosting company. You have made the correct choice in hosting companies, as we have many years experience in helping customers just like you transfer their hosting to us. We've created this easy-to-follow list for you to transfer your website to Hostek.com. | ||
+ | |||
+ | #Plan as far ahead as possible, the more detailed the better. | ||
+ | #Make sure your customers are well informed of any possible service interruption and changes they should consider well in advance. | ||
+ | #Test each site after uploading the files, importing databases and updating connection strings to make sure no errors are occurring. Use the Testing URL provided in the email after setting up hosting. | ||
+ | #Complete unfinished business, including tightening security on any ports or protocols that do not need to remain open to the public. | ||
===For sites with constantly changing data=== | ===For sites with constantly changing data=== | ||
− | The most difficult sites to move are those that have constantly changing data. The | + | The most difficult sites to move are those that have constantly changing data. The is because updates made during the backup & transfer will not be reflected in the data backup being moved. |
− | + | ||
− | + | <b>To resolve this:</b> | |
− | + | ||
− | After the site move has been completed, | + | Perform the transfer during off-peak hours. In addition display a "under construction" page on both the new and old server while the transition is in progress. |
+ | |||
+ | After the site move has been completed, update your DNS as quickly as possible and leave the old site stopped. In some cases pointing the website on the previous host to the database on the new website will allow both sites to run without inconsistent data. | ||
+ | |||
+ | Another solution to insure quick switch over is setting the DNS, TTL to a low value such as 600 (10 minutes) on A records for domains being moved. | ||
+ | |||
+ | ===Pre-Migration Site Assessment=== | ||
+ | |||
+ | ;Domains List | ||
+ | :Which domains are hosted and need moved? | ||
+ | :Do they require SSL? | ||
+ | :Are there any other hostnames that point to the site such as a sub-domain or alias? | ||
+ | :Special requirements such as a Virtual Directory or Sym Link? | ||
+ | |||
+ | ;Database List | ||
+ | :Types of databases? | ||
+ | :User and permissions for each user? | ||
+ | :Password for each user? | ||
+ | |||
+ | ;Domains with Mail | ||
+ | :Which domains USE mail? | ||
+ | :How do users access email, POP, IMAP, Web? | ||
+ | :Server URL for POP, SMTP, IMAP and Web? | ||
+ | :Special requirements such as SSL? | ||
+ | |||
+ | ;Domains with FTP | ||
+ | :User and permission such as directory, read/write for each user? | ||
+ | :Passwords for each user? | ||
+ | |||
+ | ;Registrar for each Domain? | ||
+ | :Where can the Name Servers be updated? | ||
+ | :Login for the Account? | ||
+ | |||
+ | ;DNS for each Domain | ||
+ | :Where is it managed? | ||
+ | :Will DNS management be moved? | ||
+ | :Should we set the TTL low for any to insure quick switchover? | ||
+ | |||
+ | ==Sign up for hosting== | ||
+ | The First step in transferring is to sign up for a hosting package. We offer a wide range of hosting packages that will fit your needs. After signing up for a hosting package, you will get an email with a <b>Testing URL</b> and <b>Temporary FTP</b> information. Use this information to complete the next task of moving your site files. | ||
+ | |||
+ | [http://hostek.com/hosting/web-hosting/best-web-hosting.asp Web Hosting] Windows / Linux / ColdFusion / Railo | ||
+ | |||
+ | [http://hostek.com/reseller-hosting.asp Reseller Hosting] | ||
+ | |||
+ | [http://hostek.com/hosting/vps/best-vps-hosting.asp VPS (Virtual Private Server) Hosting] | ||
+ | |||
+ | [http://hostek.com/hosting/dedicated/virtual-dedicated-hosting.asp Virtual Dedicated Hosting] | ||
+ | |||
+ | <b>Custom VPS or Infrastructure as a Service Solutions</b> contact [mailto:vps_sales@hostek.com VPS sales.] | ||
==your-provider to Hostek.com Windows Shared Hosting== | ==your-provider to Hostek.com Windows Shared Hosting== | ||
− | ===Moving | + | ===Moving Site Files and Databases=== |
#Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/". | #Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/". | ||
#Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them. | #Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them. | ||
Line 32: | Line 88: | ||
#Request a full backup of your database from your host, or create one through their control panel if you have that option. | #Request a full backup of your database from your host, or create one through their control panel if you have that option. | ||
#Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel. | #Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel. | ||
− | #Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter | + | #Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter name of the backed up database and choose a size larger than the .bak file. Enter a username and password and click 'Save'. |
− | # | + | #Follow the steps for [https://wiki.hostek.com/Backup_%26_Restore_Databases_-_MS_SQL How to Restore a MSSQL Database]. |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller. | NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller. | ||
+ | |||
+ | ===Update your domain’s DNS=== | ||
+ | *Update your domain’s DNS settings Once you have tested your site, contact your domain name registrar and change your DNS settings to the Name Servers we provided in the New Account email. Your registrar is the company you purchased your domain name from. You’ll replace your existing primary and secondary name servers with the ones we provided you in the new account email. This change will take about 12 to 48 hours to propagate throughout the internet. | ||
+ | |||
+ | ===Wait for your domain to propagate=== | ||
+ | *Wait for your domain to propagate (approximately 12-48 hours) While your domain propagation is taking effect, some will see your site on our servers and others will see the site on your old host. This will prevent any downtime. In order to receive mail from both locations, you will need to check email from both hosts. You can simply use our web mail interface to get the email that is sent to our servers during | ||
+ | |||
+ | ===Cancel with your previous host=== | ||
+ | Cancel with your previous host After the site is pointing to us, you can go and cancel the hosting account you have at your previous host. | ||
+ | |||
+ | ===Transfer your domain name to our registrar (optional)=== | ||
+ | Transfer your domain name (optional)If you would like to transfer your domain and consolidate your registration and web hosting to one source, you can request to transfer the domain. The domain transfer itself costs NOTHING; we simply add one year of registration onto the expiration date for a base price for the common .TLD's. After that, you will able to renew your domain name at the same great price. | ||
+ | A registrar transfer is the moving a domain name from one registrar to another. A registrar is the company that actually registers a domain name. | ||
+ | #You will need to log into your billing control panel at https://cp.hostek.com | ||
+ | #Click on the domains drop-down menu and click "My Domains". | ||
+ | #Scroll down to your domain name and click "Manage Domain" | ||
+ | #Click the "Registrar Lock" tab, then click the "Disable Registrar Lock" button. | ||
+ | #Click on the "Management Tools" drop-down menu and select "Contact Information" | ||
+ | #You will need to update the Admin contact email address to an email address that you can receive emails at and click "Save Changes". | ||
+ | #Click "Management Tools" drop-down and select "Get EPP Code". This will display the EPP code that you will need to provide to the registrar you are transferring to. | ||
+ | #Once you have initiated the transfer with the registrar and provided the EPP code you will receive a transfer approval email at the email address you specified. | ||
+ | |||
==your-provider to Hostek.com Windows VPS== | ==your-provider to Hostek.com Windows VPS== | ||
*We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains. | *We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains. | ||
+ | |||
+ | [[media:Hostek.com_Migration_Checklist.xls | Download this Migration Checklist]] to keep track of your migration progress. | ||
===Moving Domains=== | ===Moving Domains=== | ||
− | Familiarize yourself and your team with our [https://wcp.hostek.com Windows Control Panel]. | + | Familiarize yourself and your team with our [https://wcp.hostek.com Windows Control Panel]. We have prepared a [https://wiki.hostek.com/WCP_(Windows_based_Control_Panel) WCP Guide] to help. |
#Create the domain using the "addon domain" icon in the WCP. | #Create the domain using the "addon domain" icon in the WCP. | ||
Line 96: | Line 168: | ||
#To fix user a created user which existed before the database was restored. | #To fix user a created user which existed before the database was restored. | ||
#*<pre>USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'</pre> | #*<pre>USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'</pre> | ||
+ | #In some cases you may continue to receive errors. Try adding double slashes for the file restore paths. Here's a scripted example: | ||
+ | <pre> | ||
+ | RESTORE DATABASE [exampledatabase] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\exampledatabase.bak' | ||
+ | WITH FILE = 1, MOVE N'old_database_name_Data' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.mdf', | ||
+ | MOVE N'old_database_name_Log' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.LDF', | ||
+ | NOUNLOAD, REPLACE, STATS = 10 | ||
+ | GO | ||
+ | </pre> | ||
===Don't forget=== | ===Don't forget=== | ||
Line 101: | Line 181: | ||
*Change the DNS TTL back to default. | *Change the DNS TTL back to default. | ||
− | === Why move one at a time?=== | + | |
− | + | === Mail=== | |
+ | |||
+ | ====SmarterMail to SmarterMail==== | ||
+ | |||
+ | #See the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration] for preparing the MX record and SSL (if applicable). You can however skip the step for creating users / passwords on the new server since you will be moving everything at once. | ||
+ | #Zip the contents of the {smartermail root}\domains\yourdomain.com. | ||
+ | #FTP the files from the old server to the new, this can be done by installing a simple FTP client such as FileZilla on the VPS and connecting to the old server. | ||
+ | #On the new VPS unzip and overwrite the contents {smartermail root}\domains\yourdomain.com. | ||
+ | #Login to the SmarterMail Webmail interface, "Reload" the domain. This should cause all the users to be revealed, with their inbox, calendar and other assets intact. | ||
+ | #Complete the "Final Steps" mentioned under [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration]. | ||
+ | |||
+ | ====Any Provider to Windows & Smartermail==== | ||
+ | |||
+ | Easily migrate from any mail service. Move a single mailbox, or an entire domain, from mail services like: | ||
+ | |||
+ | Gmail | ||
+ | Yahoo! | ||
+ | Hotmail / Windows Live | ||
+ | Microsoft Exchange | ||
+ | Or even mail servers like Merak, iMail and MailEnable | ||
+ | |||
+ | We suggest following the "Preparation Steps" under the [https://wiki.hostek.com/index.php?title=Changing_Hosting_Providers#Keys_for_simple_POP.2FSMTP_Mail_Migration Keys for Simple Mail Migration]. Then follow the steps provided by SmarterMail. | ||
+ | |||
+ | http://portal.smartertools.com/KB/a1937/import-mailbox-data-to-smartermail-from-third-party.aspx | ||
+ | |||
+ | ====Why move one domain at a time?==== | ||
+ | If you setup domain X, Y, and Z via WCP, then migrate X from your old server to Hostek. If a user on X tries to email someone on domain Y or Z they'll get a kickback saying "No such user." This is because you haven't migrated the data over into these other accounts yet. The server will try to send the message locally before it goes "outside" to resolve it's IP address. Setting up new domains "as you go", will avoid this possibility. | ||
If mail is not involved in the migration, then you may not need to worry about this issue. | If mail is not involved in the migration, then you may not need to worry about this issue. | ||
+ | |||
+ | ==your-provider to VPS Mail Migration General Information== | ||
+ | There are various ways to migrate mail from an existing provider. In cases where POP is the method for retrieving mail then simply switching providers in a thoughtful preplanned manner is sufficient. | ||
+ | |||
+ | |||
+ | ===Keys for simple POP/SMTP Mail Migration=== | ||
+ | |||
+ | ====Preparation Steps for Mail Migration==== | ||
+ | #Create domain on the new server. | ||
+ | #Setup users & passwords in advance on the new server. | ||
+ | #Take note of the specific DNS details and modify the TTL. | ||
+ | #*Note the MX record. | ||
+ | #*Set the TTL for the MX record to 600 (10 minutes). | ||
+ | #*If the MX is set to "something.yourdomain.com", then also change the TTL for the A record "something.yourdomain.com" to 600 (10 minutes). | ||
+ | #Does your mailserver use SSL? Note, if the SSL mail encryption works for "mail.yourisp.com" and you're moving to a VPS then you will likely have to also purchase and have the certificate installed and insure the exact same type of SSL support works before proceeding. | ||
+ | |||
+ | ====Final Steps to complete the Mail Migration==== | ||
+ | #Plan and prepare users with what they should expect. | ||
+ | #Be sure your mail server is listening on the IP Address you will point the A record to | ||
+ | #We suggest to create or modify the A record "something.yourdomain.com" if it already exists, when you are ready to make the switch change that A record "something.yourdomain.com" to point at your VPS. | ||
+ | #When finished change the TTL for the MX record and applicable A record back to it's default (Usually 14400). | ||
+ | |||
+ | *You can use the standard ports for POP/SMTP or IMAP with or without SSL. | ||
+ | *Alternate Ports for SMTP (26) is pre-configured in our firewall and will just need configured in either SmarterMail or Cpanel. | ||
+ | |||
+ | |||
+ | ===your-provider Mail Migration any IMAP Mail Server=== | ||
+ | |||
+ | '''This can easily apply to migrating from any mail service to Linux with Cpanel.''' | ||
+ | |||
+ | We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration above. It also may be possible to find an application to migrate IMAP mail including calendars & contacts. We suggest checking into "IMAPSync". | ||
+ | |||
[[Category:Windows-VPS]] | [[Category:Windows-VPS]] | ||
[[Category:ColdFusion-VPS]] | [[Category:ColdFusion-VPS]] | ||
[[Category:VPS]] | [[Category:VPS]] | ||
+ | [[Category: Sales]] | ||
+ | [[Category:Getting Started]] |
Latest revision as of 17:42, 24 February 2015
Contents
Steps to Changing Hosting Providers
- Sign up with Hostek.com
- Transfer your site files and databases. Specific details for moving to: Shared Hosting or VPS Hosting
- Test your site(s)
- Update Your Domain Name's Name Servers NOTE: you will find the Name Server information in the New Hosting Account Email.
Planning Ahead
- Transferring hosting companies can be, and should be, easy if you follow the right steps and choose the right hosting company. You have made the correct choice in hosting companies, as we have many years experience in helping customers just like you transfer their hosting to us. We've created this easy-to-follow list for you to transfer your website to Hostek.com.
- Plan as far ahead as possible, the more detailed the better.
- Make sure your customers are well informed of any possible service interruption and changes they should consider well in advance.
- Test each site after uploading the files, importing databases and updating connection strings to make sure no errors are occurring. Use the Testing URL provided in the email after setting up hosting.
- Complete unfinished business, including tightening security on any ports or protocols that do not need to remain open to the public.
For sites with constantly changing data
The most difficult sites to move are those that have constantly changing data. The is because updates made during the backup & transfer will not be reflected in the data backup being moved.
To resolve this:
Perform the transfer during off-peak hours. In addition display a "under construction" page on both the new and old server while the transition is in progress.
After the site move has been completed, update your DNS as quickly as possible and leave the old site stopped. In some cases pointing the website on the previous host to the database on the new website will allow both sites to run without inconsistent data.
Another solution to insure quick switch over is setting the DNS, TTL to a low value such as 600 (10 minutes) on A records for domains being moved.
Pre-Migration Site Assessment
- Domains List
- Which domains are hosted and need moved?
- Do they require SSL?
- Are there any other hostnames that point to the site such as a sub-domain or alias?
- Special requirements such as a Virtual Directory or Sym Link?
- Database List
- Types of databases?
- User and permissions for each user?
- Password for each user?
- Domains with Mail
- Which domains USE mail?
- How do users access email, POP, IMAP, Web?
- Server URL for POP, SMTP, IMAP and Web?
- Special requirements such as SSL?
- Domains with FTP
- User and permission such as directory, read/write for each user?
- Passwords for each user?
- Registrar for each Domain?
- Where can the Name Servers be updated?
- Login for the Account?
- DNS for each Domain
- Where is it managed?
- Will DNS management be moved?
- Should we set the TTL low for any to insure quick switchover?
Sign up for hosting
The First step in transferring is to sign up for a hosting package. We offer a wide range of hosting packages that will fit your needs. After signing up for a hosting package, you will get an email with a Testing URL and Temporary FTP information. Use this information to complete the next task of moving your site files.
Web Hosting Windows / Linux / ColdFusion / Railo
VPS (Virtual Private Server) Hosting
Custom VPS or Infrastructure as a Service Solutions contact VPS sales.
Moving Site Files and Databases
- Open an FTP(File Transfer Protocol) client on your computer. If you do not have one, you can download FileZilla for free at "http://filezilla-project.org/download.php/".
- Connect to your site on your old host. Generally, the connection details will either be in an e-mail you received from them or listed in your control panel with them.
- Once connected, you should see two sets of files, local (files on your computer) and remote (files on your website). Under your local files, create a folder to store your site files.
- Once the folder is created, open that folder on the local side. Then, select all the files on the remote site and download them into that folder.
- Wait for the transfer of all files to complete. This may take several minutes.
- Once the transfer is complete, disconnect from the server. Then connect to your site on our server using the FTP details that we sent in your account details e-mail.
- On the remote side, open the /wwwroot folder. Also, on the local side, if there is a 'www', 'wwwroot', or 'public_html' folder, open that folder as well. #Select all files on the local side and upload them to the remote side.
- Wait for the transfer of all files to complete. This may take several minutes.
- Done - your site files have been moved.
Databases
MSSQL
- Request a full backup of your database from your host, or create one through their control panel if you have that option.
- Once you have the full database backup (should be a .bak file), login into your WCP control panel at "https://wcp.hostek.com" using the same e-mail address and password as your billing control panel.
- Once logged in, select 'MS SQL', and click 'Add MS SQL database'. Enter name of the backed up database and choose a size larger than the .bak file. Enter a username and password and click 'Save'.
- Follow the steps for How to Restore a MSSQL Database.
NOTE: If you have any issues restoring the database due to the size or structure of the database, you may need to upload the backup file to your website and ask support to restore the database. If you do this, it is recommended that you zip the backup file before uploading it as that will make it much smaller.
Update your domain’s DNS
- Update your domain’s DNS settings Once you have tested your site, contact your domain name registrar and change your DNS settings to the Name Servers we provided in the New Account email. Your registrar is the company you purchased your domain name from. You’ll replace your existing primary and secondary name servers with the ones we provided you in the new account email. This change will take about 12 to 48 hours to propagate throughout the internet.
Wait for your domain to propagate
- Wait for your domain to propagate (approximately 12-48 hours) While your domain propagation is taking effect, some will see your site on our servers and others will see the site on your old host. This will prevent any downtime. In order to receive mail from both locations, you will need to check email from both hosts. You can simply use our web mail interface to get the email that is sent to our servers during
Cancel with your previous host
Cancel with your previous host After the site is pointing to us, you can go and cancel the hosting account you have at your previous host.
Transfer your domain name to our registrar (optional)
Transfer your domain name (optional)If you would like to transfer your domain and consolidate your registration and web hosting to one source, you can request to transfer the domain. The domain transfer itself costs NOTHING; we simply add one year of registration onto the expiration date for a base price for the common .TLD's. After that, you will able to renew your domain name at the same great price. A registrar transfer is the moving a domain name from one registrar to another. A registrar is the company that actually registers a domain name.
- You will need to log into your billing control panel at https://cp.hostek.com
- Click on the domains drop-down menu and click "My Domains".
- Scroll down to your domain name and click "Manage Domain"
- Click the "Registrar Lock" tab, then click the "Disable Registrar Lock" button.
- Click on the "Management Tools" drop-down menu and select "Contact Information"
- You will need to update the Admin contact email address to an email address that you can receive emails at and click "Save Changes".
- Click "Management Tools" drop-down and select "Get EPP Code". This will display the EPP code that you will need to provide to the registrar you are transferring to.
- Once you have initiated the transfer with the registrar and provided the EPP code you will receive a transfer approval email at the email address you specified.
your-provider to Hostek.com Windows VPS
- We recommend setting up each domain using WCP as you move them, not all at one time. Doing so ensures there are less complications with mail delivery between two domains.
Download this Migration Checklist to keep track of your migration progress.
Moving Domains
Familiarize yourself and your team with our Windows Control Panel. We have prepared a WCP Guide to help.
- Create the domain using the "addon domain" icon in the WCP.
- When initially logging into WCP the domain which was used for referencing your VPS will be listed and new domains added.
- If you selected a database server be installed locally or remotely it should be integrated with your control panel and databases can be added under each domain using the appropriate Icon.
- Note if you ordered the FREE SmarterMail edition which only includes mail for a single domain, upon adding your second domain you may encounter an error. If so contact support for upgrading your SmarterMail license or disabling the action for adding new domains to the mail server.
- DNS zones are automatically created for new domains, for the name servers which are used for domains added to your VPS click on the "Site Details" icon within the WCP for the domain in question.
- Copy files to your VPS. Use FTP directly from your VPS to transfer site files, this is extremely fast and efficient.
- Test the domain. Each domain will have a "Testing URL" within the "Site Details" area of WCP, note that if the database is not moved over and or DSN not created you may encounter errors.
- Prepare the DNS for moving. Before switching your DNS we suggest a shorter TTL such as 300 (5 minutes), after this change you must wait out the original TTL before the new value will take affect. For example if your original TTL was 7200 seconds (2 hours) you must wait 2 hours after submitting any change before the new TTL will be take effect.
- Switch your DNS. By now your site is tested and you're ready to make the switch.
- In most cases we suggest moving the database first so data will be consistent from the old location to the new.
SSL
- Our Windows Control Panel has provisions for creating a CSR and installing a new certificate but you cannot "import" an existing certificate. There are two ways to resolve "moving" a certificate to a Windows server easily.
Pkey format
- Export the certificate in PKey format. Within the certificate manager, export the current certificate in PKey format, you will be asked for a "passphrase" assign one and remember it.
- Copy the certificate to the new server.
- Open IIS on your VPS, open the main server node then click on the icon "Server Certificates" found under >> IIS >> Server Certificates.
- Click import and follow the prompts.
- Edit the bindings for the specific site to assign the certificate
- Right click on the website in Sites >> your-website.abc select "Edit Bindings".
- Select "Add" change the type to https, select the IP Address, select the "SSL Certificate" from the drop down.
Re-key the certificate
- Using this method could render the SSL certificate expired on the old server.
- Click on the "Dedicated SSL" icon in WCP.
- Fill in the appropriate information to generate a CSR.
- At your certificate provider request a "rekey" using the CSR provided from WCP.
- After receiving the new certificate back from your provider, complete the installation in WCP.
Databases
MSSQL
- Add the database and user in MSSQL using the WCP under the correct domain.
- Set the database to single user mode on the new server.
USE database_name ALTER DATABASE [DB_NAME_HERE] SET SINGLE_USER WITH NO_WAIT
- Using SQL Studio Manager restore from backup selecting the file you exported from your previous server.
- Set the database to multi user mode on the new server.
USE database_name ALTER DATABASE [DB_NAME_HERE] SET MULTI_USER WITH NO_WAIT
- To fix user a created user which existed before the database was restored.
USE database_name Exec sp_change_users_login 'auto_fix','USERNAME'
- In some cases you may continue to receive errors. Try adding double slashes for the file restore paths. Here's a scripted example:
RESTORE DATABASE [exampledatabase] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\exampledatabase.bak' WITH FILE = 1, MOVE N'old_database_name_Data' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.mdf', MOVE N'old_database_name_Log' TO N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\exampledatabase.LDF', NOUNLOAD, REPLACE, STATS = 10 GO
Don't forget
- Scheduled tasks, add them on the new server remove them from the old.
- Change the DNS TTL back to default.
SmarterMail to SmarterMail
- See the Keys for Simple Mail Migration for preparing the MX record and SSL (if applicable). You can however skip the step for creating users / passwords on the new server since you will be moving everything at once.
- Zip the contents of the {smartermail root}\domains\yourdomain.com.
- FTP the files from the old server to the new, this can be done by installing a simple FTP client such as FileZilla on the VPS and connecting to the old server.
- On the new VPS unzip and overwrite the contents {smartermail root}\domains\yourdomain.com.
- Login to the SmarterMail Webmail interface, "Reload" the domain. This should cause all the users to be revealed, with their inbox, calendar and other assets intact.
- Complete the "Final Steps" mentioned under Keys for Simple Mail Migration.
Any Provider to Windows & Smartermail
Easily migrate from any mail service. Move a single mailbox, or an entire domain, from mail services like:
Gmail Yahoo! Hotmail / Windows Live Microsoft Exchange Or even mail servers like Merak, iMail and MailEnable
We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration. Then follow the steps provided by SmarterMail.
http://portal.smartertools.com/KB/a1937/import-mailbox-data-to-smartermail-from-third-party.aspx
Why move one domain at a time?
If you setup domain X, Y, and Z via WCP, then migrate X from your old server to Hostek. If a user on X tries to email someone on domain Y or Z they'll get a kickback saying "No such user." This is because you haven't migrated the data over into these other accounts yet. The server will try to send the message locally before it goes "outside" to resolve it's IP address. Setting up new domains "as you go", will avoid this possibility.
If mail is not involved in the migration, then you may not need to worry about this issue.
your-provider to VPS Mail Migration General Information
There are various ways to migrate mail from an existing provider. In cases where POP is the method for retrieving mail then simply switching providers in a thoughtful preplanned manner is sufficient.
Keys for simple POP/SMTP Mail Migration
Preparation Steps for Mail Migration
- Create domain on the new server.
- Setup users & passwords in advance on the new server.
- Take note of the specific DNS details and modify the TTL.
- Note the MX record.
- Set the TTL for the MX record to 600 (10 minutes).
- If the MX is set to "something.yourdomain.com", then also change the TTL for the A record "something.yourdomain.com" to 600 (10 minutes).
- Does your mailserver use SSL? Note, if the SSL mail encryption works for "mail.yourisp.com" and you're moving to a VPS then you will likely have to also purchase and have the certificate installed and insure the exact same type of SSL support works before proceeding.
Final Steps to complete the Mail Migration
- Plan and prepare users with what they should expect.
- Be sure your mail server is listening on the IP Address you will point the A record to
- We suggest to create or modify the A record "something.yourdomain.com" if it already exists, when you are ready to make the switch change that A record "something.yourdomain.com" to point at your VPS.
- When finished change the TTL for the MX record and applicable A record back to it's default (Usually 14400).
- You can use the standard ports for POP/SMTP or IMAP with or without SSL.
- Alternate Ports for SMTP (26) is pre-configured in our firewall and will just need configured in either SmarterMail or Cpanel.
your-provider Mail Migration any IMAP Mail Server
This can easily apply to migrating from any mail service to Linux with Cpanel.
We suggest following the "Preparation Steps" under the Keys for Simple Mail Migration above. It also may be possible to find an application to migrate IMAP mail including calendars & contacts. We suggest checking into "IMAPSync".