Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Title

...	...	@@ -1,1 +1,1 @@
1		-Database Dumps
	1	+DB Dumps

Content

...	...	@@ -1,6 +1,72 @@
1		-=== **Step 1: Execute the PowerShell Script** ===
	1	+=== **Step 1: Set Up the Environment** ===
2	2
3	3	1. (((
	4	+**Install Tortoise Git**:
	5	+
	6	+* Tortoise Git is a version control tool that will allow you to pull the latest scripts from your Git repository.
	7	+* To install it:
	8	+** Download and install Tortoise Git.
	9	+)))
	10	+1. (((
	11	+**Create Folders**:
	12	+
	13	+* Open **File Explorer** on your PC and navigate to C:\.
	14	+* Create the following folder structure:
	15	+
	16	+C:\EBsphere\devops\master
	17	+
	18	+* Inside C:\EBsphere\devops\master, you will store the latest scripts pulled from the Git repository.
	19	+)))
	20	+1. (((
	21	+**Pull Latest Scripts Using Tortoise Git**:
	22	+
	23	+* Right-click on the master folder in **File Explorer**.
	24	+* Select **TortoiseGit > Git Clone**.
	25	+* Clone the repository if it's not already cloned, or choose **TortoiseGit > Pull** to pull the latest changes.
	26	+* After pulling the latest updates, ensure the sql-script-db.ps1 script is available.
	27	+)))
	28	+
	29	+----
	30	+
	31	+=== **Step 2: Set Up PowerShell 7.5** ===
	32	+
	33	+1. (((
	34	+**Install PowerShell 7.5**:
	35	+
	36	+* If you do not have PowerShell 7.5 installed, download it from the [[PowerShell GitHub releases page>>url:https://github.com/PowerShell/PowerShell/releases/tag/v7.5.0]].
	37	+* Install PowerShell 7.5 and ensure it's added to your system PATH.
	38	+)))
	39	+1. (((
	40	+**Open PowerShell 7.5 in Administrator Mode**:
	41	+
	42	+* After installation, **right-click on PowerShell 7.5** and select **Run as Administrator**.
	43	+)))
	44	+1. (((
	45	+**Set the Path to the Script Directory**:
	46	+
	47	+* In PowerShell, set the working directory to where the script is located (C:\EBsphere\devops\master\devops\sql):
	48	+
	49	+{{{
	50	+ }}}
	51	+
	52	+Set-Location -Path C:\EBsphere\devops\master\devops\sql
	53	+)))
	54	+1. (((
	55	+**Check the PowerShell Version**:
	56	+
	57	+* Ensure you're using the correct version of PowerShell:
	58	+
	59	+{{{
	60	+ }}}
	61	+
	62	+$PSVersionTable.PSVersion
	63	+)))
	64	+
	65	+----
	66	+
	67	+=== **Step 3: Execute the PowerShell Script** ===
	68	+
	69	+1. (((
4	4	**Prepare the Parameters**:
5	5
6	6	* Set up the parameters needed for the script. These include:
...	...	@@ -38,7 +38,7 @@
38	38
39	39	----
40	40
41		-=== **Step 2: Validate the Results** ===
	107	+=== **Step 4: Validate the Results** ===
42	42
43	43	1. **Check in Azure Storage**:
44	44	1*. Go to your Azure Storage Account (use Azure portal or Azure Storage Explorer) and check if the necessary files (stored procedures, tables, functions, triggers, etc.) have been uploaded to the designated container.
...	...	@@ -49,15 +49,13 @@
49	49	1*. Query the devops_sqlhashes table:
50	50
51	51	{{{
52		- }}}
53		-
54		-(((
	118	+ }}}(((
55	55	SELECT * FROM devops_sqlhashes;
56	56	)))
57	57
58	58	----
59	59
60		-=== **Step 3: Debugging (If Needed)** ===
	124	+=== **Step 5: Debugging (If Needed)** ===
61	61
62	62	* **Check Logs**: If the process didn't work as expected, look for any logs generated by the script or check the Azure logs for any issues during the file upload.
63	63	* **Error Messages**: Review any error messages printed to the PowerShell console or Microsoft Edge window for debugging.