This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject

→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Migrating from SQL to Compact

mzimmerer
Engaged Sweeper

‎12-07-2018 07:38 PM

While I see there's tools to migrate from Compact to SQL, are there any resources for doing the opposite? Coming into an existing deployment without the need for SQL, only 1gig db.
Labels:
0 Kudos
3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee

‎12-10-2018 06:32 PM

mzimmerer wrote:
While I see there's tools to migrate from Compact to SQL, are there any resources for doing the opposite? Coming into an existing deployment without the need for SQL, only 1gig db.


Unfortunately, you can't go from SQL server to compact, at least not with our tools. I've never tried it but you can try doing it with a 3rd party tool. But I have no idea if it will work
0 Kudos
mzimmerer
Engaged Sweeper
In response to Esben_D

‎12-10-2018 07:22 PM

Charles.X wrote:
mzimmerer wrote:
While I see there's tools to migrate from Compact to SQL, are there any resources for doing the opposite? Coming into an existing deployment without the need for SQL, only 1gig db.


Unfortunately, you can't go from SQL server to compact, at least not with our tools. I've never tried it but you can try doing it with a 3rd party tool. But I have no idea if it will work


Thanks Charles,
I'm giving this a shot using
https://github.com/ErikEJ/SqlCeToolbox
I'll report back in case anyone else stumbles down this path.
0 Kudos
mzimmerer
Engaged Sweeper
In response to mzimmerer

‎12-11-2018 01:41 PM

mzimmerer wrote:
Charles.X wrote:
mzimmerer wrote:
While I see there's tools to migrate from Compact to SQL, are there any resources for doing the opposite? Coming into an existing deployment without the need for SQL, only 1gig db.


Unfortunately, you can't go from SQL server to compact, at least not with our tools. I've never tried it but you can try doing it with a 3rd party tool. But I have no idea if it will work


Thanks Charles,
I'm giving this a shot using
https://github.com/ErikEJ/SqlCeToolbox
I'll report back in case anyone else stumbles down this path.


Incase anyone else hits this.. I was unable to complete this due to error. We're looking at rebuilding the installation from scratch as a last resort.

We found no way to migrate the lansweeper DB to SQL compact or to azure SQL, pretty well stuck on SQL once that trigger is pulled.
0 Kudos

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now