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?
  2. satya Moderator

    YOu can use the SQL2000 compatibility mode to script out, SQL version 7 still matches with that setting.
  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?
  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.

Share This Page