Initialize empty database from SQL scripts generated by Redgate SQL Source Control
I have a folder with SQL scripts generated by Redgate SQL Source Control:
I want to create a new SQL server database on the CI server to run integration tests as a part of the pipeline. I can easily create a new SQL server docker container. But then I need to create all tables, function etc. I want to use SQL scripts generated by Redgate SSC but I don't see the way to run them in the pipeline. I tried to run them manually but it's quite hard because it requires to run them in a proper sequence because there are dependencies between different SQL objects.
Is there a known way to do it?
UPDATE: Currently I'm looking into Building a Database Directly from Object-level Source Scripts approach.
The Scripts Folder created by SQL Source Control represents the create statements but to build a new database they need to be ordered correctly. SQL Compare Pro can be used to read in a scripts folder as its source using /scripts1, and if you set the target (/s2 and /db2) to be your empty database, it will create (and apply if you use the /sync) a deployment script to create your database. The SQL Compare Pro CLI comes with SQL Toolbelt Essentials or Flyway Enterprise, and is available as a traditional command line executable as well as from Dockerhub. Please contact support@red-gate.com if you're unsure about licensing.
Here is an example:
sqlcompare /scripts1:"C:\Scripts Folder\" /s2:"my_server\my_instance,myport;encrypt=true;trustservercertificate=true" /db2:MyTargetDB /sync
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by