mohamedibrahim93

$connectionString = ""
$rootPath = "./source"


$watch = [System.Diagnostics.Stopwatch]::StartNew()

"Staring Process..."
"----------------------------"

mohamedibrahim93

$srvname="localhost"
$dbname="Coderush"
$dbusername="sa"
$dbpassword="123"
$scriptFileName= "D:\PSScripts\Test.sql"

$dbobjects = @(
"dbo.Product",
"dbo.VW_Users",

mohamedibrahim93

<#
    .SYNOPSIS
        Data Import Wizard provides a way to generate or update content from an external file.
        
    .DESCRIPTION
        The import file uses the properties "Name" and "Id" to help match existing items.
        
    .NOTES
        Mohamed AL-Driny - https://github.com/mohamedibrahim93
#>

mohamedibrahim93

<#
    .SYNOPSIS
        Data Import Wizard provides a way to generate or update content from an external file.
        
    .DESCRIPTION
        The import file uses the properties "Name" and "Id" to help match existing items.
        
    .NOTES
        Mohamed AL-Driny - https://github.com/mohamedibrahim93
#>

mohamedibrahim93

DECLARE @search nvarchar ( 200 ) 
SET @search = 'dbo' 
SELECT DISTINCT
o.name AS Object_Name,
o.type_desc 
FROM
	sys.sql_modules m
	INNER JOIN sys.objects o ON m.object_id = o.object_id 
WHERE
	m.definition LIKE '%' + @search + '%'

mohamedibrahim93

public struct Constants
{
    public string Value { get; }
    private Constants(string value)
    {
        Value = value;
    }
    public override string ToString()
    {
        return Value;

mohamedibrahim93

<#
    .SYNOPSIS
        Data Import Wizard provides a way to generate or update content from an external file.
        
    .DESCRIPTION
        The import file uses the properties "Name" and "Id" to help match existing items.
        
    .NOTES
        Mohamed AL-Driny - https://github.com/mohamedibrahim93
#>