Click here to Skip to main content
12,826,671 members (30,018 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
Hello everyone, If anyone can help me in my problem I would really appreciate that.

I have done a C# windows application with Mysql as a database. I have finished my application and made a setup project.
The problem is, I don't know how will I have my database available on the other computers? Should I install Mysql server on the computers?

I have installed my application on another computer, but it is showing "unknown database".

Thanks for your Support,
Posted 30-Jan-13 8:41am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

What's the problem? Database or RDBMS?

Database, if you need, is usually included in installation (you can include any file, as you know). RDBMS is more usually claimed as a prerequisite for your product. If you need to deploy it with your application, refer to MySql documentation.

Also, it would be useful to see here:[^].

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

This is what I normally do when I want to deploy a database involved application.

1. Make a setup that includes all my application, MySQL setup, MySQL script to create database
2. when someone run the setup install the MySQL setup first and configure the user Id and pwd and other setting in MySQL-UI
3. Run the Utility Application that I developed which accepts the database server, Uid and password
4. using MySQL.Cmd execute the script which creates the database,table, stored procedure etc
5. Copy all other exes and configuration files to the local drive

thats all your done!!
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

Thanks Guys,

Jibesh, I actually understood the concept from your solution. I have used Mysql Workbench through which I exported my Database. I installed Mysql on the other computer and imported the Database, and it worked!

Thanks again...!

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100