It's posible to migrate a database from localdb to sqllite

Question

0.00/5 (No votes)

See more:

Hello
I'm new to C # but I did a project where I use localdb.
I have two questions that I need help
1º how to compile the project with an aggregated localdb database?
2nd
If migration is possible, is it better to use SqlLite to distribute the application?
thank you very much for any help

What I have tried:

nothing at this time because i dont know how to

Posted 25-Mar-21 5:00am

miguel santos 2021

Updated 25-Mar-21 9:08am

PIEBALDconsult

v2

Add a Solution

3 solutions

Solution 2

Maybe you can use a migration tool like dbMigration.NET, see:
best-relational-database-migration-tools[^]

You might also be interested in LiteDB as this is only a small dll that can easily be distributed with your application, see: best-databases-for-a-small-net-application[^]

Posted 25-Mar-21 7:43am

RickZeeland

Updated 26-Mar-21 21:55pm

v2

Comments

miguel santos 2021 27-Mar-21 3:25am

thanks

Solution 3

Do you think, since you are new to C#, that creating an application that also requires a database (and even more so, two of them if you are going to migrate the data with your own code).

If new to programming, take baby steps. First, get comfortable with C#. You should also get comfortable with how a database works with applications.

Then - and only then - will you be able to write the code to do these things together. And finally, connect to more than one database at a time (if you really want to) and move the data.

Posted 25-Mar-21 9:08am

W∴ Balboos, GHB

Comments

miguel santos 2021 27-Mar-21 3:24am

Thank you very much for the comment.
But for other responses I had, what is at issue at this moment is just to get that, when I compile for the project setup, to include the litedb as well as the db, because if you install the litedb and do the restore from the db the project works perfectly on any pc,
if you can teach me how to overcome this, I am immensely grateful.
thanks again for your patience

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2021-03-25T05:12:00

"localdb" isn't a database, it's a "special" connection string that accesses the instance of SQL Server that is located in the same machine.

You don't include SQL databases "inside your app" by compiling it: you install an instance (or use an existing instance) and you access that. Your installation program should be responsible for do that, and creating any initial database if one doesn't exist already.

It's possible that you might get away with SqLite instead of SQL Server, but it depends on your app, your data, what you want to do with it, and how your code is written. If you expect only one user to ever access the DB, then you may get away with it. If multiple users are to access it simultaneously, then you need a multiuser DB like SQL server or MySql.
And your code will also feature heavily here: SqLite does not support everything SQL does - for example it doesn't support stored procedures - so if you are using features, they may not be present or will be very different.