locked
SQL server migration assessment. RRS feed

  • Question

  • Hi,

    Can someone provide me the all required tsql scripts for studying sql 2000 server instance  and databases?

    This is required as i am restricted to read access(During phase 1) to assess sql 2000  sql 2012 migration and client will run the scripts the output. 

    Wednesday, October 1, 2014 11:59 AM

Answers

  • Hi Lakshman, 

    If possible you can ask your client to run SQL Server Upgrade advisor and they  can share the report generated with you.

    Here is link to learn about the sql server upgrade advisor: 

    • http://technet.microsoft.com/en-us/library/ms144245(v=sql.90).aspx
    • http://www.microsoft.com/en-in/download/details.aspx?id=14845

    Regards Harsh

    • Marked as answer by Lakshman MS Wednesday, October 8, 2014 11:22 AM
    Wednesday, October 8, 2014 10:56 AM

All replies

  • Hi Lakshman,

    According to your description, we need to verify that if you want to perform the migration from SQL Server 2000 to SQL Server 2012. If so, we are not able to migrate from SQL Server 2000 to SQL Server 2012 directly as SQL Server 2012 supports upgrade from only the following versions: SQL 2005 SP4 or SQL 2008 SP2 or SQL 2008 R2 SP1.

    Therefore, to migrate from SQL Server 2000 to SQL Server 2012, we need to make the migration in two steps as follows. For more details, please review this blog: Migration SQL Server 2000 to SQL Server 2012.

    1. Make a first migration from SQL Server 2000 to SQL Server 2008.
    2. Make a second migration from SQL Server 2008 to 2012.


    Thanks,
    Lydia Zhang

    Thursday, October 2, 2014 12:44 PM
  • I know it is two step process. what i need is tsql scripts for assessment i.e  to study  sql 2000 instance(db,sp,triggers,replication) and to recommend migration path.

    The scripts can be shared to client to run and share us the results as we are restricted to read only access on sql 2000 instance.

    Tuesday, October 7, 2014 8:51 AM
  • I know it is two step process. what i need is tsql scripts for assessment i.e  to study  sql 2000 instance(db,sp,triggers,replication) and to recommend migration path.

    The scripts can be shared to client to run and share us the results as we are restricted to read only access on sql 2000 instance.

    Hi Lakshman,

    Since SQL Server 2000 has been out of support, if you need to study SQL Server 2000 instance, I recommend you start from Book Online Documents.
    Getting Started with SQL Server Books Online: http://msdn.microsoft.com/en-us/library/aa256841(v=sql.80).aspx


    Thanks,
    Lydia Zhang


    Wednesday, October 8, 2014 10:39 AM
  • Hi Lakshman, 

    If possible you can ask your client to run SQL Server Upgrade advisor and they  can share the report generated with you.

    Here is link to learn about the sql server upgrade advisor: 

    • http://technet.microsoft.com/en-us/library/ms144245(v=sql.90).aspx
    • http://www.microsoft.com/en-in/download/details.aspx?id=14845

    Regards Harsh

    • Marked as answer by Lakshman MS Wednesday, October 8, 2014 11:22 AM
    Wednesday, October 8, 2014 10:56 AM