Pinned Loading

1. dbatools dbatools Public

   Forked from dataplat/dbatools

   🚀 SQL Server automation and instance migrations have never been safer, faster or freer

   PowerShell

2. Export MSSQL schema and SQL Logins w... Export MSSQL schema and SQL Logins with PowerShell. This script will export your schema definitions for tables, stored procs, triggers, functions and views and SQL Logins to .sql files

   1

   # Usage:  powershell .\ExportSchemaSqlLogins.ps1 "SERVERNAME" "DATABASE" "C:\YourOutputPath\DATABASE"

   2

   3

   4

   # Start Script

   5

   Set-ExecutionPolicy RemoteSigned

3. SqlServerSchemaBackup: This script g... SqlServerSchemaBackup: This script generates all database object's schema (table, view, function, stored procedure, userdefine data types etc) of all databases in the Sql Server. Sql Server Agent supports to run powershell scripts already. So you can define a scheduled job daily or weekly to backup only schema for source control to cover early versions of objects.

   1

   # Usage: 

   2

   # step 1: Open Powershell as an admin. 

   3

   # step 2: Go to the SqlServerSchemaBackup.ps1 script file existing folder.

   4

   # step 3: Type  .\SqlServerSchemaBackup.ps1

   5

4. microsoft/vscode-mssql microsoft/vscode-mssql Public

   Visual Studio Code SQL Server extension.

   TypeScript 1.6k 465

5. Export MSSQL schema with PowerShell.... Export MSSQL schema with PowerShell. This script will export your schema definitions for tables, stored procs, triggers, functions and views to .sql files

   1

   # Usage:  powershell ExportSchema.ps1 "SERVERNAME" "DATABASE" "C:\YourOutputPath\DATABASE"

   2

   3

   4

   # Start Script

   5

   Set-ExecutionPolicy RemoteSigned

6. azuredatastudio azuredatastudio Public

   Forked from microsoft/azuredatastudio

   Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capabi…

   TypeScript