Exporting database schema and data to a sql script

Hey guys today i wanted to export my all schema and data from a database to a script file. While i was searching on the net i found the following command that we can you. Hope this will be helpful to you guys too.
Command to run which will create schema and database:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql”
Command to run which will create schema:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql” -schemaonly
Command to run which will create data:
C:C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql” -dataonly

Comments

Post a Comment

Your comments...

Popular posts from this blog

Installing Microsoft SharePoint Server 2013

Image
Yesterday we downloaded the newest preview version of Microsoft SharePoint 2013. Preview version is available in technet http://technet.microsoft.com/en-us/evalcenter/hh973397 . I configured a virtual machine with the preview version and following are the steps I followed to configure the SharePoint 2013. Prerequisites Installed OS – Microsoft Windows server 2008 R2 SP1 Installed Microsoft SQL Server 2008 R2 SP1 Find more information about the prerequisites from the link http://technet.microsoft.com/en-us/library/cc262485(office.15).aspx Downloaded SharePoint 2013 installer using link http://technet.microsoft.com/en-us/evalcenter/hh973397 Above link will download .img file named SharePointServer_en-us.img. I installed winrar and extracted the content inside the .img file to a separate folder. Installation steps Then I ran the installer and it gave following message. Which said I need to have couple of updates need to install in to the system. Microsoft has provided a tool...
Read more

SharePoint 2010 – Making title column required on Document and Picture libraries

Image
If you want to make title field mandatory when uploading files to a document library do the following steps. This will make title column required on the document library. Go to document library “Library Settings page” Go to the “Advanced settings” page in the library settings page Make “Content Types” Allow management of content types to “Yes” and press ok. In the “Library Settings page” click the “Document” content type Click on Title In the Column settings make it as Required. Now once you upload a document to the library it will ask for the Title of the document. Hope this small tutorial will help you to complete your solution .
Read more

SharePoint 2010 My Site–Error when opening the My Profile page

Image
Today just after I configure My Site host in my environment I tried to test the My Site pages by navigating to those pages. But I got the following error once I go to those pages. Following is the stack trace. Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.Office.Server.Utilities.UrlUtility.SafeAppendQueryStringParameter(String strUrl, String strKey, String strValue)     at Microsoft.SharePoint.Portal.WebControls.EditProfileButton.OnPreRender(EventArgs e)     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecur...
Read more