Migrate DB from SQL CE to SQL Server 2012 (or 2008)

[mbast]

Hi,
is there a official mpath to migrate an existing database from SQL CE to a real SQL Server?

I tried to use the "CompactToServer.exe", but it tells me that the Schema does not match (i have Schema Version 62 on the source side = SQL CE) and Schema Version 20 on the target.

The DB on target Server has been created with the same Setup program

[mbast]

I found the solution on my own: i had to install Lansweeper service on our SQL Server so the Service can update the Schema!
After the services starts, the schema is updated. After that, i removed the lansweeper service from the server and was able to transfer with onboard tools ( CompactToServer.exe).
I think you'll have to overthink this because not everybody want's to install software on a SQL server in a production environment (in my case i did this in a lab environment).

[Hemoco · Accepted solution]

mbast wrote:

I think you'll have to overthink this because not everybody want's to install software on a SQL server in a production environment (in my case i did this in a lab environment).

You don't need to install the service on the SQL server, you can install it anywhere you want (on the lansweeper server). The service needs to point to the sql database.

[mbast]

We are currently on Lansweeper 5.1.17 (i installed this Version because having big issues with IE 11), so i am sure i did use the same setup on our production SQL Server (Advanced install - only Lansweeper database!).

I tried this twice now, every time with the same result: Schema is Version 20 and DB can't be copied by CompactToServer.exe


Here are some parts out of install.log:

2013-12-04 08:10:24.239 Windows version: 6.1.7601 SP1 (NT platform: Yes)
2013-12-04 08:10:24.239 64-bit Windows: Yes
2013-12-04 08:10:24.239 Processor architecture: x64
2013-12-04 08:10:24.239 User privileges: Administrative
2013-12-04 08:10:24.270 64-bit install mode: No
2013-12-04 08:10:24.270 Created temporary directory: C:\Windows\TEMP\2\is-NN6MR.tmp
2013-12-04 08:10:24.707 OS: osWin2008SrvR2
2013-12-04 08:10:24.707 Installer version: 5.1.17
2013-12-04 08:10:24.770 IIS7: Not exists HKLM\Software\Microsoft\INetStp\Components @W3SVC
2013-12-04 08:10:25.800
2013-12-04 08:10:25.800 ------------------------------------------------------------
2013-12-04 08:10:25.800 ---------------- Lansweeper Setup Started ----------------
2013-12-04 08:10:25.800 ------------------------------------------------------------
2013-12-04 08:10:25.800
2013-12-04 08:17:06.695 Checking connection to localhost ...
2013-12-04 08:17:08.788 Checking rights for user: ...
2013-12-04 08:17:08.788 Checking rights for user: ... succeeded!
2013-12-04 08:17:09.288 Checking if the Lansweeper database exists ...

...

2013-12-04 08:17:24.874 ------------------------------------------------------------
2013-12-04 08:17:24.874 --------------- Running Postinstall tasks ---------------
2013-12-04 08:17:24.874 ------------------------------------------------------------
2013-12-04 08:17:24.874
2013-12-04 08:17:24.874
2013-12-04 08:17:24.874 ------------------------------------------------------------
2013-12-04 08:17:24.874 ------------- Installing Lansweeper Database -------------
2013-12-04 08:17:24.874 ------------------------------------------------------------
2013-12-04 08:17:24.874
2013-12-04 08:17:24.874 Creating Lansweeper Database...
2013-12-04 08:17:25.390 Creating Lansweeper Database... done.
2013-12-04 08:17:25.390 Building Lansweeper Database Tables...
2013-12-04 08:17:28.420 Building Lansweeper Database Tables... done.
2013-12-04 08:17:28.420 Building Lansweeper Database Views...
2013-12-04 08:17:29.497 Building Lansweeper Database Views... done.
2013-12-04 08:17:29.497 Building Lansweeper Database Procedures...
2013-12-04 08:17:29.513 Building Lansweeper Database Procedures... done.
2013-12-04 08:17:29.513 Populating Lansweeper Database...
2013-12-04 08:17:49.972 Populating Lansweeper Database... done.
2013-12-04 08:17:49.988 Create login lansweeperuser...
2013-12-04 08:17:49.988 Grant DB access to lansweeperuser...
2013-12-04 08:17:50.035 Grant DB access to lansweeperuser... done.
2013-12-04 08:17:50.050 Add rolemember to lansweeperuser...
2013-12-04 08:17:50.050 Add rolemember to lansweeperuser... done.
2013-12-04 08:17:50.050 Sharing Actions folder...
2013-12-04 08:18:06.996 Need to restart Windows? No
2013-12-04 08:19:00.146
2013-12-04 08:19:00.146 ------------------------------------------------------------
2013-12-04 08:19:00.146 --------------- Lansweeper Setup Finished ---------------
2013-12-04 08:19:00.146 ------------------------------------------------------------

[Hemoco]

You need to ensure that both installations are running the same Lansweeper version before attempting the migration. Run our latest 5.1 installer, which can be found here, on both servers and choose Upgrade. Note that the Lansweeper service must be started in order to perform an upgrade, as the service upgrades the database. For further migration instructions, contact support@lansweeper.com