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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 upgrading SQL 7 to SQL 2000

Author  Topic 

pmilza
Starting Member

1 Post

Posted - 2004-01-17 : 17:16:10
Hi,
I’m trying to find information on doing an unattended upgrade of SQL 7 SP4 to SQL 2000? I've only come across documentation in BOL and the web on recording and using an.iss file to perform an initial installation. We deployed SQL 7 hands free using the method documented in BOL to over 300 servers in our environment and are now looking to upgrade (finally). Any thoughts or help you could provide would be greatly appreciated



thanks,

pete

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-01-18 : 18:58:13
I believe everything that I did in my articles on upgrading could be scripted into an exe with calls to the SQL servers via OSQL. Here are my articles:

Part 1: http://www.sqlteam.com/item.asp?ItemID=9066
Part 2: http://www.sqlteam.com/item.asp?ItemID=9465

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page
   

- Advertisement -