Export Database Scripts in SQL Server Management Studio


show more Exporting database scripts in SQL Server Management Studio 2012 (NEW) provides you with in-depth training on Developer. Taught by David Gassner as part of the ASP.NET Essential Training show less
please wait ...

Exporting database scripts in SQL Server Management Studio 2012 (NEW)

The Database Publishing Wizard that was included in Visual Web Developer 2008 is not a part of Visual Studio Express 2012. If you go to the Database Explorer and right-click on your data connection, you'll see that the tool to get to that wizard is no longer available. That ability, however, to export the structure and data from one or more database tables is now available in SQL Server Management Studio for SQL Server 2012, and I'll show you how to do that here. I'm working with that same database, My Bookstore, this time seen through SQL Server Management Studio. I'll go to my database, My Bookstore. I'll right-click and choose Tasks > Generate Scripts, and that takes me to something called the Generate and Publish Scripts wizard. On the introduction screen, I'll click Next. Now, I'll indicate whether I want to script the entire database or only a single table.

Those are your choices. I'll export just one database table: My Author's table. I'll select i...

Exporting database scripts in SQL Server Management Studio 2012 (NEW)
Video duration: 3m 20s 6h 24m Beginner Updated Feb 13, 2013

Viewers:

Exporting database scripts in SQL Server Management Studio 2012 (NEW) provides you with in-depth training on Developer. Taught by David Gassner as part of the ASP.NET Essential Training

Subjects:
Developer Web
Software:
ASP.NET
Author:
please wait ...