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 |
|
Neptune79
Starting Member
4 Posts |
 Posted - 2004-02-10 : 09:36:32
|
| Hi,I am doing research/preparation on upgrading from SQL 7 to 2000.I came across some notes saying that there are some upgrade issues.Two issues which affect me are objects that have been renamed using the sp_rename stored procedure and stored procedures that reference system tables.These will apparently not be converted/created in the new database.How can I overcome/resolve these issues?Thanking you in advance. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-02-10 : 17:51:12
|
| OK, I have no clue why either of these would be issues. Is it dependent upon the technique that you use to upgrade them? I did our SQL 7 to 2000 upgrade by using detach/attach. In fact, I even wrote a couple of articles about the process.Here they are...Part 1: http://www.sqlteam.com/item.asp?ItemID=9066Part 2: http://www.sqlteam.com/item.asp?ItemID=9465EDIT: If the issue with the sprocs is that the system tables they referred to were changed, they won't be automatically updated to reflect the change. It's always iffy to reference system tables directly. Consider using the Information_Schema views instead.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
Neptune79
Starting Member
4 Posts |
Posted - 2004-02-11 : 07:32:29
|
| Did you have to manually upgrade the meta data services tablesand repository database? |
|
|
|
Neptune79
Starting Member
4 Posts |
Posted - 2004-02-11 : 09:24:47
|
| Hi,I'm starting to get a bit confused and nervous.If I upgrade the current server(instead of doing a clean install on a new machine)according to the Microsoft steps,it looks to me thatthe only steps that need to be followed are:- run setup from the cd to upgrade the existing installation- repopulate full-text catalogs- update statistics- upgrade the meta data services tables and the repository databaseWhat about transferring logins,scripting the jobs etc.?Do I no longer need to worry about these steps? Are these automatically included in the upgrade?What about the dts packages? Do they also get copied/upgraded to automatically? I haven't seen anything anywhere that requires you to copy/backup the packages.Hope you can answer my questions.Thanks again in advance! |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-02-11 : 13:11:34
|
| Ummm.... meta data services tables and the repository database? Sorry, I don't know what you're referring to here. Is this server involved in replication or something? I haven't worked with that, but from what I've read, you have to upgrade the servers in a specific order if that's the case.If you're upgrading the server "in place" instead of moving to a new one, then the logins, jobs, and dts packages should all remain and not need to be transferred, but I haven't done this, so that's just my assumptions. Also be sure to do several backups and test them before you do something like this, because it could be a real bearcat if things go wrong.One of the big advantages to going to a new server is that you can do a test run and check out the results before committing your life to it. It's just so much easier to "recover" if something goes wrong because there's really no recovery involved.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
Neptune79
Starting Member
4 Posts |
Posted - 2004-02-18 : 04:18:46
|
| Ok,it looks like i'm going to go the side-by-side installation route.I just wanted to make sure,if i install 2000 as a named instance will i then have to change the connection path in all my client applications in order for it to connect to SQL server 2000?Thanks in advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-19 : 13:06:29
|
| Neptune79, yes you will have to modify the clients. You can either change the connection string or just create an alias.Tara |
|
|
|
|
|
|
|
|
Upgrade SQL 7 to 2000