Click here to Skip to main content
16,015,481 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I have an ASP.NET project which has used MS-SQL as a database, with version control being taken care of by Ankh SVN. MS-SQL databases in ASP.NET are stored in the App_Data folder, which means that they are versioned by subversion.

I'm wanting to switch from MS-SQL to MySQL, but MySQL databases don't seem to be stored in the visual studio project folder... which surely means that they won't be included in any subversion commits (?).

What's the best way to ensure an MySQL database is included in subversion commits? E.g. Is it possible to have the MySQL database in the App_Data folder like with MS-SQL?

Thanks!
Posted

1 solution

Typically you can export the entire database in a plain text file.

Using PHP My Admin you can select the database and then EXPORT it and it will store all the database into a text file in your downloads folder... Then you could put that file into your subversion folder.

A ittle bit of extra work but it could work.

Good luck!
 
Share this answer
 
Comments
Lee Reid 9-Apr-12 6:44am    
Presumably I would have to do this every time I made any change to it, before committing?
Joan M 9-Apr-12 7:19am    
Yes, this is the best I can imagine in that environment... I know it is not the best but it would work...

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900