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

How to get SharePoint dll version using JavaScript quickly

If you are working on SharePoint apps development you will need to know the SharePoint dll version to put webparts in to the page. In webparts we need to provide the SharePoint dll version in the  '  In this sinario you can use following service url and make a quick call and get the version of the SharePoint dll on Office 365 SharePoint Online as well as SharePoint Onprem. /_vti_pvt/buildversion.cnf SharePoint On Premise output vti_encoding:SR|utf8-nl vti_buildversion:SR|15.0.4737.1000 SharePoint Online Office 365 output as of 04/07/2017 vti_encoding:SR|utf8-nl vti_buildversion:SR|16.0.6621.1204 Function for get the version no.     getSharePointVersion: function () {         var ver = null;         $.ajax({             url: "/_vti_pvt/buildversion.cnf",             async: false,         }).done(function (result) {             var lines = result.trim().split('\n');             if (lines.length == 2) {                 var versionProperty = li
Read more

SharePoint App Only Registration Key Renewal script

################################## ## Checking secret working ################################## $clientSecret = 'xxxxx' Connect-PnPOnline -Url "https://xxxx.sharepoint.com/sites/DevSite" -ClientId 67c86709-5348-45b9-a16b-9b7a983a20c2 -ClientSecret $clientSecret Get-PnPConnection Get-PnPListItem -List LookupList ################################### ## Get all Keys #################################### $msolcred = get-credential connect-msolservice -credential $msolcred $clientId = "67c86709-5348-45b9-a16b-9b7a983a20c2" $keys = Get-MsolServicePrincipalCredential -AppPrincipalId $clientId $keys ################################## ## Remove keys ################################## Remove-MsolServicePrincipalCredential -KeyIds $keys.KeyId -AppPrincipalId $clientId ######################################## ## Generate key for 3 years ######################################## $bytes = New-Object Byte[] 32 $rand = [System.Security.Cryptography.RandomNumberGenerator]::Cre
Read more