Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlTable | Get-SqlScripter | Set-Content -Path D:scriptsscript.sql
  2. Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlStoredProcedure | Get-SqlScripter
  3. Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlView | Get-SqlScripter
  4.  
  5. $ mssql-scripter -S localhost -d AdventureWorks -U sa
  6.  
  7. $ mssql-scripter -S localhost -d AdventureWorks -U sa
  8.  
  9. $ mssql-scripter -S localhost -d AdventureWorks -U sa
  10.  
  11. $ mssql-scripter -S localhost -d AdventureWorks -U sa –schema-and-data > ./output.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement