cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
codeslayer
Engaged Sweeper
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?

1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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.


View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
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.


New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now