Dump SQL Server Express' DB Schema
I am quite feeling lost since SQL Server 2005, SQL Server Express don't come with the "Enterprise manager" any more... I used to do many stuff under that Enterprise manager for SQL Server 2000 before.
One simple task I need to do is dump my database schema and transfer to another server, I can easily do that before in Enterprise manager, now I don't even know hot to dump and generate the SQL statement... fortunately I found this tool:
http://www.codeplex.com/sqlhost
Database Publishing Wizard
Download the Current Release (1.1)
The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
- It generates a single SQL script file which can be used to recreate a database when the only connectivity to a server is through a web-based control panel with a script execution window.
- It connects to a web service provided by your hoster and directly creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a command-line interface. In addition, it can integrate directly into Visual Studio 2005 or Visual Web Developer 2005.
Related posts:
- To "refresh" a SqlDataSource.
- asp:ControlParameter vs asp:FormParameter
- output a line in a batch *without* crlf
- Write code with no getters???
- Dump SQL Server Express' DB Schema
- My suggestions on Web2py's route design
- Good comparing of GAE Data Store .vs. Amazon Simple DB .vs. MS SSDS
- Very good articles on MVC, MVP and more.
- Presenter First approach in MVP
- ASP.NET MVC Preview 3 just released
Search related in web:
