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 [email protected] 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
- Insert leading spaces, then the value to a field in varchar(10)
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- No PK or FK when exporting SQL Server database
- SQL Server SELECT LAST N Rows
- SSRS Query execution failed for dataset
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- Union two selects removing duplicates base on some columns (not the full row)
- SQL fill gaps with hold
- Create login and logout rows from single row
- Create Index without name while creating table
- Extracting SQL Server table data to parquet file
- SQL, How to convert VARCHAR to bigint?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- SQL Server query to find all permissions/access for all users in a database
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- inserting data into SQL DB from C# ASP.NET
- Display the average number of days between a customer's last and second to the last transaction
- Fastest way to determine if record exists
- Unrecognized column name that I define
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?