Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2017 03:43 PM
I have to migrate a lansweeper installation (v6040) to an other machine/server _AND_ move it's database from an external MSSQL server to a local compact SQL database that came with it.
The reason for the migration is related to performace and maintenance issues. The machine that is currently hosting the lansweeper installation is running other processes that slow-down the web-interface and the concept of hosting the database on a distant SQL server is also not very practical.
Which steps should be made to migrate all files and db-data to the new place?
The reason for the migration is related to performace and maintenance issues. The machine that is currently hosting the lansweeper installation is running other processes that slow-down the web-interface and the concept of hosting the database on a distant SQL server is also not very practical.
Which steps should be made to migrate all files and db-data to the new place?
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2017 04:00 PM
Unfortunately it's not possible to migrate from an SQL Server database to an SQL Compact database. Since you're making this move for performance reasons though, we would instead recommend moving to a local SQL Server. You could use the free SQL Server Express edition. SQL Server Express 2008R2 and newer have a database capacity of 10GB compared to the 4GB of SQL Compact, SQL Server is also more performant than SQL Compact.
Instructions for moving your database can be found in this article. If you wish to install your scanning service and web server on the same machine as your database, you can follow this article almost entirely instead, the only difference being the source of your database back up coming from a different machine than your website and key folder backups.
Instructions for moving your database can be found in this article. If you wish to install your scanning service and web server on the same machine as your database, you can follow this article almost entirely instead, the only difference being the source of your database back up coming from a different machine than your website and key folder backups.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2017 04:00 PM
Unfortunately it's not possible to migrate from an SQL Server database to an SQL Compact database. Since you're making this move for performance reasons though, we would instead recommend moving to a local SQL Server. You could use the free SQL Server Express edition. SQL Server Express 2008R2 and newer have a database capacity of 10GB compared to the 4GB of SQL Compact, SQL Server is also more performant than SQL Compact.
Instructions for moving your database can be found in this article. If you wish to install your scanning service and web server on the same machine as your database, you can follow this article almost entirely instead, the only difference being the source of your database back up coming from a different machine than your website and key folder backups.
Instructions for moving your database can be found in this article. If you wish to install your scanning service and web server on the same machine as your database, you can follow this article almost entirely instead, the only difference being the source of your database back up coming from a different machine than your website and key folder backups.