Merging Lansweeper databases

[jlorz]

We've just purchased a single premium copy of lansweeper and probably want to purchase 3 - 7 more for other regional units of the company.

We'd like to be able to separate the databases by region for each of our regional IT managers but then merge them into a central database for global reporting.

Is that possible? I haven't been able to find anything in the documentation or forums yet about merging this type of information within the Lansweeper database and can only think of ways that would require exporting data from each of the databases into Excel.

Thanks.

John

[Hemoco]

It's possible, but not by default.
If you have enough sql server knowledge you can get it to work using the data transformation services build into sql server.
With this you can transfer from datasource A (branch sqlserver) into datasource B (central SQL server)

http://en.wikipedia.org/wiki/Data_Transformation_Services

Take your time to look at the documentation, if you can't get it to work please let us know.

The only tricky part to merge all the data is to make sure that the "computername" is unique in all locations.