How do I add a database to software

Question

0.00/5 (No votes)

See more:

, +

I'm working on a visual studio wpf project that would be used by several users.
I want every user that installs the software to have a local database connected to an online database (hosted)... for this purpose I decided to go with sql server merge replication.
My question is; in order to add the database to the application is it best to:

1. configure my database schema and merge in sql server management studio and connect it to the application directly;(a database will be created if it doesn't exist)

2.configure my database schema and merge in sql server management studio then detach my database from my server and add the MDF file to the application files and include it in the setup;

Also; just checking; merge relication doesn't accept the server on the web as a publisher so in this case I need to make every user of the application a publisher and the web server a subscriber.. Am I correct here or am I missing something?

What I have tried:

I know it's a basic question but I was wondering if the merge replication will work if i use the second option

Posted 23-Dec-19 2:38am

izz moe

Updated 23-Dec-19 8:29am

Add a Solution

Comments

[no name] 23-Dec-19 10:05am

Neither "SQL management studio" nor "merge replication" is fundamental to where you are in your project. Start with "what is a database". Local versus remote. Access methods.

1 solution

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)

RickZeeland · Answer 1 · 2019-12-23T08:29:00

I'm afraid this is not a "basic question", database replication is a difficult subject.

Here is an interesting article: Database Synchronization with the Microsoft Sync Framework -- Visual Studio Magazine[^]

And maybe you can learn something from this discussion about working with an offline database: c# - Desktop application which can work offline when no connectivity with SQL Server - Stack Overflow[^]