SQL Server Performance

scripting version 7 db in 2005?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Jul 1, 2011.

  1. Trev256b Member

    I need to script all the objects etc in a database in 2005 - however the database is version 7. it is not listed under the 'tasks-script' option when you right click on the database - as it is a previous version. Is there a simple way to script the objects in the database without restoring on a sql server 7 instance?
    Trev256b, Jul 1, 2011
    #1

  2. satya Moderator

    YOu can use the SQL2000 compatibility mode to script out, SQL version 7 still matches with that setting.
    satya, Jul 6, 2011
    #2

  3. Trev256b Member

    i changed the db to 2005 compatibilty mode by restoring a abackup on 2005 instance - and then scripted it out. do you foresee any problems with that?
    Trev256b, Jul 10, 2011
    #3

  4. satya Moderator

    I dont think so any issues with this approach. As long as you can execute the script on required SQL instnance it should be ok.
    satya, Jul 15, 2011
    #4

Share This Page