Oki B430d-beige PrintSuperVision 4.0 User Guide - Page 14

SQL management tools such as SQL Server Management Studio.

Get Oki B430d-beige PDF manuals and user guides View all Oki B430d-beige manuals
Add to My Manuals
Save this manual to your list of manuals

Page 14 highlights

If the requirement is to switch to a SQL server from SQL Express - when the database size exceeds the SQL Express limit - the following steps are recommended:  Copy the SQL database to the SQL server  Ensure that SQL authentication is used and not Windows authentication if the database is located in another computer  Run PSV Setup utility, and in the database tab, enter the name of the SQL server and the database name  Click Apply to save the changes  The pop up screen with the 3 options - Create, Change, Migrate - will appear. Select Change.  Note that if SQL server is used, to backup and restore the PSV database, use the SQL management tools such as SQL Server Management Studio. Notice in the Enterprise Edition (not available in Pro) that you may also test the connection to the server and enter a new name for the server if you selected SQL Server Express or another SQL database such SQL 2000, 2005, 2008, 2012 that have already been installed on the server. 14

  • 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
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
14
If the requirement is to switch to a SQL server from SQL Express
–
when the database
size exceeds the SQL Express limit
–
the following steps are recommended:
Copy the SQL database to the SQL server
Ensure that SQL authentication is used and not Windows authentication if the
database is located in another computer
Run PSV Setup utility, and in the database tab, enter the name of the SQL server
and the database name
Click Apply to save the changes
The pop up screen with the 3 options
–
Create, Change, Migrate
–
will appear.
Select Change.
Note that if SQL server is used, to backup and restore the PSV database, use the
SQL management tools such as SQL Server Management Studio.
Notice in the Enterprise Edition (not available in Pro) that you may also test the
connection to the server and enter a new name for the server if you selected SQL Server
Express or another SQL database such SQL 2000, 2005, 2008, 2012 that have already
been installed on the server.