The following are some tips for upgrading to SQL Server 2005:
• Upgrade to SQL Server 2005 from SQL Server 7.0 or SQL Server 2000.
• Run Upgrade Advisor before upgrading to determine if any product changes are expected to break existing applications.
• The SQL Server Database Engine, Analysis Services, and Reporting Services can be upgraded by the setup program.
• SQL Server Integration Services, the replacement for Data Transformation Services (DTS), is installed side by side with DTS. You can run DTS packages using the DTS runtime components.
• SQL Server 2005 Notification Services is installed side by side with Notification Services 2.0. You must migrate instances of Notification Services to SQL Server 2005 when you upgrade the SQL Server Database Engine.
• Use the Surface Area Configuration tool after upgrading to enable or disable SQL Server 2005 services, network protocols, and features.Labels: 2005, DTS, microsoft, migration, SQL Server
Microsoft is launching its new products:
1. Visual Studio 2005
2. SQL Server 2005 &
3. BizTalk Server 2006
Starting Dec 9, 2005
Bill Gates will be in Bangalore, India on 9th Dec for the launch.
The products are scheduled to be launched in other major cities also:
Bangalore Dec. 9, 2005Palace Grounds ,
The Bangalore Palace,
PO- 193, Vasantha Nagar.
Mumbai Dec. 13, 2005Grand Hyatt
Off Western Express Highway
Santacruz (East).
Pune Dec. 14, 2005
Le Meridien
Raja Bahadur Mill Road.
Chennai Dec. 15, 2005Le Royal MeridienBusiness District,
1 GST Road, St Thomas Mount.
New Delhi Dec. 16, 2005The Grand InterContinental
Barakhamba Avenue,
Connaught Place.
Hyderabad Dec. 20, 2005Taj Krishna
Road No. 1, Banjara Hills.
Kolkata Dec. 21, 2005The Oberoi Grand15,
Jawaharlal Nehru Road.
If you are interested in joining for the launch, please register on the Microsoft site:
http://www.microsoft.com/india/ready2005/register.aspx
The SQL Server TechNet site has been republished as a TechCenter. Just as MSDN DevCenters focus on information for developers, TechCenters focus on information for IT professionals such as DBAs. The site layout of the SQL Server TechCenter is similar to those already published for Exchange and Windows Server 2003. The TechCenters will evolve over time to incorporate customer feedback and deliver new information as it is published.
One requirement for TechCenters is to organize their content into 8 content areas, such as Getting Started and Operations. SQL Server customers often work in one technology at a time (Database Engine, Analysis Services, DTS, etc.) and want to focus on content for that technology. The SQL Server TechCenter uses a technique from the Windows Server TechCenter to support both navigation paths:
Browse by TaskHas one navigation page for each content area, with links to Web content relevant to IT professionals performing those types of tasks. To support technologies, the sets of links on each task navigation page are organized by technology. There is also a Technical Library fly-out in the left-hand column that provides links to the Browse by Task pages.
Browse by TechnologyHas one navigation page for each technology, with links to Web content relevant to that technology. To support the content areas, the sets of links on each task navigation page are organized by task. There is also a Technologies fly-out in the left-hand column that provides links to the Browse by Technology pages.
The new TechCenter should improve your ability to find IT professional information for SQL Server. The new navigation pages will, for the first time, give IT professionals a set of links to all the major SQL Server content on the Web, including links to the relevant major nodes in the copy of the SQL Server Books Online in the MSDN Library.