PowershellScripts/DummyMSSQLdbCreate.ps1 at master · caanone/PowershellScripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

[string]$dninstance= '.\SQLEXPRESS'
[string]$dbname= "testdb"
[string]$dbtblname= "test"
[string]$dbuser= "sa"
[string]$dbpassword= "123456"
[int]$insertcount= 100000
[int]$duprow= 100
[int]$interval= 10000

$createquery="
 CREATE DATABASE [$dbname]
GO "

$tablecreatequery=" USE [$dbname]
GO
/****** Object:  Table [dbo].[$dbtblname]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[$dbtblname]([a] [varchar](max) NULL,[b] [nvarchar](max) NULL,[c] [varchar](max) NULL,[d] [varchar](max) NULL,[e] [varchar](max) NULL,[f] [varchar](max) NULL,[g] [varchar](max) NULL,[aa] [varchar](max) NULL,[bb] [varchar](max) NULL,[cc] [varchar](max) NULL,[dd] [varchar](max) NULL,[ee] [varchar](max) NULL,[ff] [varchar](max) NULL,[gg] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
"

$insertquery="
USE [$dbname]
INSERT INTO $dbtblname
(a,b,c,d,e,f,g,aa,bb,cc,dd,ee,ff,gg)
VALUES ('$a','$b','$c','$d','$e','$f','$g','$aa','$bb','$cc','$dd','$ee','$ff','$gg')
GO "


Invoke-SQLcmd -ServerInstance $dninstance -query $createquery -Username $dbuser -Password $dbpassword -Database "MASTER"
Invoke-SQLcmd -ServerInstance $dninstance -query $tablecreatequery -Username $dbuser -Password $dbpassword -Database $dbname


For ($i=0; $i -lt $insertcount; $i++) {
[string]$a= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$b= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$c= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$d= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$e= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$f= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$g= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$aa= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$bb= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$cc= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$dd= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$ee= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$ff= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
[string]$gg= -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})


For ($i=0; $i -lt $duprow; $i++) {
Invoke-SQLcmd -ServerInstance $dninstance -query $insertquery -Username $dbuser -Password $dbpassword -Database $dbname
}


-join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})+ -join ((65..90) + (97..122) | Get-Random -Count 300 | % {[char]$_})
   Start-Sleep -s $interval

    }