SQL script
An SQL script is a file or command sequence containing SQL statements for defining, querying, initializing, or modifying database structures and data.
Building Web APIs with ASP.NET Core
An SQL script is a file containing SQL statements that can be reviewed and executed to create or modify database structures or data.
- How it is used
- Deploys missing production database structures through reviewed SQL rather than applying migrations directly in application startup.
- How deep it goes
- Explains generation, DBA review, and tool-based execution, while deferring detailed SQL commands and alternative implementation mechanics.
- Examples
- Uses the dotnet-ef migration-script command and SSMS as the concrete generation and execution workflow.
- What you can do after
- Operate/configure production database deployment by generating, reviewing, and executing an EF Core SQL script.
Read how Building Web APIs with ASP.NET Core explains SQL script →
Rust Servers, Services, and Apps
A SQL script is a stored sequence of SQL statements intended for execution against a database.
- How it is used
- Uses plain SQL files to create application tables and seed test data before Rust database access code queries them.
- How deep it goes
- Explains file placement, table definition, seed inserts, execution, and verification, but does not detail migration management.
- Examples
- Demonstrates ezy_course_c4 creation, two inserted course records, psql execution, and a subsequent SELECT query.
- What you can do after
- Operate/configure PostgreSQL by creating a database table, loading test rows, and verifying them from the SQL shell.
Read how Rust Servers, Services, and Apps explains SQL script →
Related concepts
- psql meta-commandused by · A psql meta-command is a backslash-prefixed instruction interpreted by the psql command-line client rather than by the SQL server.
- migration bundle applicationalternative to · A migration bundle is a deployable executable containing Entity Framework Core migrations that applies those migrations to a database without requiring the .NET SDK or command-line tools.
- databaseproduces · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- database tableproduces · A database table is a relational database structure that organizes records into rows and defined columns.
- dotnet-efproduced by · dotnet-ef is the command-line tool for performing Entity Framework Core design-time tasks, including managing migrations and updating databases.
- dacpacproduces · A DACPAC is a SQL Server data-tier application package containing definitions of database objects for schema deployment.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.