VB.NET: Is windows form application project deployment with Mysql database is feasible?

Question

I am a PHP developer and not so familiar with to VB.NET. I am developing a system for Tailor Shop.
I have facing following problems regarding database……please help ……

I tried SQL Server CE: I found that this is not helpful to me because its limitations and most of the times it shown me the errors.
(One of the errors is:"Expression evaluation caused an overflow. [Name of function (if known) =] ")

I tried SQLite : I found that SQLite db is also not helpful to me (again due to its limitation) because this database does not support data with other than English letters.
The Case: I want to store person name in my regional language i.e. - Hindi (name = "विक्रम") but SQLite database does not support it (it shows "?????").

(I thought – SQL Server CE or SQLite would be easy for project deployment)

I want to try Mysql database now:
This is what I love very much to work with. This is perfect database for my needs.

My Question Is:-

Is windows form application (standalone) project with Mysql database easy to deploy on client machine? And How?

xpda · Accepted Answer · 2013-07-25 05:24:30Z

1

You can make add a Setup and Deployment project to the vb.net solution, and include MySql in it. One way to do this is copy the MySQL install file with your project installation, then when your application runs, if it doesn't find MySQL, ask the user if it should be installed.

answered Jul 25, 2013 at 5:24

xpda

15.9k8 gold badges54 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vikram Over a year ago

OK googled same but, MySQL Server is near about 200MB while my s/w is hardly 5MB. Is it possible to attach only MySQL Database Files to project (like SQLite Or SQL S CE : File based database) ??

xpda Over a year ago

Here are some options for that. It's not as simple as some database systems. stackoverflow.com/questions/49378/…

Collectives™ on Stack Overflow

VB.NET: Is windows form application project deployment with Mysql database is feasible?

Is windows form application (standalone) project with Mysql database easy to deploy on client machine? And How?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Is windows form application (standalone) project with Mysql database easy to deploy on client machine? And How?

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related