Is there any "Access-like" tool for sql server and that is web based? I mean having rich controls and automatically creating web forms.
My goal is to create an offline database in SQL开发者_JAVA技巧 server. I just don't know what is the best tool to use.
You can use access with a SQL Server backend, though this of course is not web based.
As far as I know, there is nothing that will create a CRUD web application for you.
I suggest reading and learning about ASP.NET and ASP.NET/MVC, with either C# or VB.NET.
There are many tools that help and assist with the data access - ORM tools like nHibernate and Entity Framework, but these will not create the data for you.
SQL Server also supports the OData protocol for exposing data on the web.
Do you mean managing sql server from a web inteface ? http://sqlwebadmin.codeplex.com check this
The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are. Using its built-in features, you can do the following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server or Microsoft SQL Server Desktop Engine (MSDE)
- Perform ad-hoc queries against databases and save them to your file system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
精彩评论