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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-01-22 : 15:46:42
|
| Knowing that SQL is very sensitive to the Server names, If I have a server name on NT4.0 say "MoneyTalk" which has SQL7.0 installed with bunch of databases, and I decide to change to Win2000 and say that I have a new server name "Taxes" already build on a different hardware with SQL2000 already installed. If I now want my application to use this win2000 server rather than the NT server what steps do I need to take and can all this be achieved at once or will I have to:1) Upgrade SQL7.0 to SQL2000 on MoneyTalk, and than move the database to Taxes, What happens to the database even though there was a change in server name from moneytalk to taxes .2)Can I just take the database from moneytalk even though it is sql7.0 and place it in SQL2000 server or no...Thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-22 : 16:14:56
|
| You could just do a backup of the database on MoneyTalk or detach the database from the server, then copy the file over to Taxes, then either do a restore or an attach (depending upon which option you picked in the first step). By doing a restore or an attach, SQL Server will automatically upgrade the database for you (not possible from 6.5 to 7.0 or 2k). But you have to keep in mind that your database is now a 2k database and if you haven't tested everything, somethings might not work. You could keep your compatibility level at 70 though even though you are running on a 2k server. Check out compatibility level in BOL. |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-01-27 : 10:43:02
|
| Don't forget your logins, DTS Packages and SQLAgent jobs. JamesH. |
|
|
|
|
|
|
SQL Server Migration