Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-15 : 09:25:49
|
Shay writes "Hello
Sql server is quite new to me but I have to upgrade aSql6.5 to Sql7. i'm going to upgrade it to anew machine and i'm thinking of using the "upgrade wizard" that comes with Sql7 (there is an option to make a two computer upgrade) I have to give the new machine the same Nt server and Sql name (since this name is configured on hundreds of client computers on the organization).
what i thought of doing is:
first: upgrade server and databases to a third machine with sql7
second: transfer the databases from the third machine to the production Sql7 server.
Questions:
1)what are the ways to transfer adatabase from one sql7 server to another (remember that i'm not a Sql expert yet) as WHOLE I mean with all objects,definitions,users,roles,rules etc'.
2)Does the upgrade utility does checkings on the Sql6.5 database (dbcc check,check65.exe and other integrity checks) before the upgrade?
I'd be happy to hear answers and other tips about this case.
thanks
shay" |
|
|
|
|
|
transferring whole database