How do i deploy MySQL Database to another computer?
-
I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is ***** :P so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf or .sdf??? Plz help me! :) and if possible please tell me or post a website which can help me deploy the database to another computer to use. This is a project which i need to submit to my university :) so plz tell me what files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project :) Thanx loadz in advance :)
-
I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is ***** :P so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf or .sdf??? Plz help me! :) and if possible please tell me or post a website which can help me deploy the database to another computer to use. This is a project which i need to submit to my university :) so plz tell me what files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project :) Thanx loadz in advance :)
swaroop09 wrote:
so do i have to install mySQL server to each and every computer that i need to run this software?
Yes, you do.
swaroop09 wrote:
cant i get a single database like MS SQL Server ?? .mdf or .sdf???
There's no such thing. Even for SQL Server files, you have to install at least the SQL Server Express Edition. You can't just throw an .MDF file on a machine and expect the app to use it. How do you deploy an app using MySQL?? A little research[^] would be in order.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008