I request to add support for other versions of MySQL too, such as MySQL 5.5/5.6 because availablity of support for any MySQL 5.1 forces WebMatrix users to stick with MySQL 5.132 votes
It would be great if next update adds an import and export option for mysql database to the webmatrix22 votes
WebMatrix 3 contains a frustrating bug when I enter a connection string in the Publish settings dialog (and validate it). The connection string is correct, but when I hit save, it forgets the connection string immediatly. The value in that field is not saved.
This makes it impossible for me to sync a SQL (non CE) database to a remote host. However Web Deploy might be complex software, this is a stupid bug.
Any help appreciated.6 votes
I would be glad if it were possible to synchronize databases. Just so you do not have to touch it to an external device that can be carried out from the WebMatrix9 votes
I have mysql database that i can change with any program.
I made new php simple site, connected mysql database, when im trying to create new database im getting en error about syntax. If im creating table in for example phpmyadmin and then trying to change in webmatrix everything is ok.
Any suggestion to this?
Alexei, best regards16 votes
It would be nice if we can do copy-paste (or drug and drop) of the table data between two data bases (i.e. sdf files) including the format definition as well the contents. This is usefull when we import the table templates from multiple examples.2 votes
I can't seem to reset my MySQL password anywhere, & can't find help via google/MSN either.6 votes
Не удалось создать базу данных.
Unable to connect to any of the specified MySQL hosts.
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
в MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
в Microsoft.WebMatrix.DatabaseManager.MySqlDatabase.MySqlDatabaseProvider.CreateDatabase(String adminConnectionString, String databaseName, String userName, String password)
в Microsoft.WebMatrix.DatabaseManager.IisDbManagerModuleService.CreateDatabase(DatabaseConnection databaseConnection, String configPathState)
в Microsoft.WebMatrix.DatabaseManager.Client.DBManagerController.CreateDatabase(ProviderInfo providerInfo, DatabaseConnection databaseConnection)
в System.Threading.Tasks.Task.Execute()0 votes
We’re looking into this. Thank you.
right click on table > copy to clipboard >
- short name
- long name
- insert statement
- update .....6 votes
Let’s see how many votes this gets!
In addition to the MySQL support, it would be great, if WebMatrix would support PostgreSQL databases too.126 votes
It would be great if I could just create and host a mysql database right from webmatrix without third-party programs.9 votes
It would be nice if we could manage mongo db inside webmatrix41 votes
I've just installed Webmatrix 2 on my Windows 7 64bits system and I'm playing around from W3school tutorials.
Everything goes well until I try to create SQL Server Compact database, either from the link in right pane and from the New database button in the ribbon. Then Webmatrix stops working.
In the databases view there is no way to insert multiline tekst into table fields.
Please make it possible to insert multiline tekst into the fields.3 votes
Since MySQL and SQL Server are supported, for those of us who have to write to Oracle DBs, adding in support for ODP.NET and PL/SQL would be fantastic.15 votes
This is great stuff, but no options with SQl server logins, i mean choosing login users.8 votes
I don't know if it was the upgrade to version 2 but I no longer have the option to add a new table definition within the middle of other fields. The only option I have is to tab and add a table definition at the end. I no longer see the column menu to add a column item. What should I do to correct this? I hope I do not have to rekey all 100+ items in my table to get one field into a new location. Please assist....1 vote
When I have mysql db, and enter to any table I can delete any row in this table. But after DB/Table refresh it appear like was not removed..4 votes
Right click table , select definition an you can edit table, HOWEVER no way to set the row value as uniqe, no way to change identity seed, and when you create relation between tables there is no way to set rule for the relation ex. cascade delete, etc. - all this is available when you open same db in visual studio, the editor there allows you to do all that, so my guess it should be easy to add to webmatrix too3 votes
We implement a subset of the functions available in VS to try to remain simple. As needed, we can look to add more.
- Don't see your idea?