Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 to SQL 2005 Expand / Collapse
Author
Message
Posted Thursday, July 16, 2009 7:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 15, 2009 2:26 PM
Points: 2, Visits: 14
We will be converting from SQL2000 to SQL2005, are there any 'DOs', 'Don'ts', or 'Gotcha'. Also, do we need any extra tool(s) for SQL2005 to view jobs/views/SP, etc.?
Post #754141
Posted Tuesday, July 21, 2009 2:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:44 AM
Points: 84, Visits: 424
By default Management Studio will be installed as part of SQL 2005 installation. SSMS is a one tool which can be used to perform all sql server related activities like administration,querying. In simple words the SSMS performs both the operation of EM & QA which was in SQL 2000.

For Migration from 2000 to 2005, follow the conventioinal and adviced method given by microsoft.
Post #756395
Posted Friday, July 24, 2009 10:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 15, 2009 2:26 PM
Points: 2, Visits: 14
Thanks for the information. Is there a cheat sheet or some guide (or a cross reference) which can help us with 2005. For example, In SQL 2000, to create/update jobs, you go to 'Management/SQL Server Agent/Jobs' and how to do same in SQL2005? Or is it very intuitive??
Post #759279
Posted Tuesday, July 28, 2009 8:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:44 AM
Points: 84, Visits: 424
MSDN, which i believe the best and got all the information for both GUI and T-SQL. There are some other stuffs also available over WEB.
Post #760809
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse