axStart: How to restore an AX 3.0 SQL 2000 backup in sql 2005

[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!257.entry
==============


[FONT='Arial','sans-serif']It is not so hard to do this trick as long you know what is changed. In SQL 200 the user is owner of the database but in SQL 2005 the Schema is the owner. Next a user is assigned to the schema. When we restore a SQL 2000 backup in SQL 2005. A new schema is created for this database. The schema name is equal to the user name. This user is also available on the database but not on the highest level of the database. In SQL 2000 we used a change owner script to make it work.  In SQL 2005 we have to change the schema. [/FONT]
[FONT='Arial','sans-serif']exec sp_MSforeachtable "ALTER SCHEMA new_schema TRANSFER ? PRINT '? modified' "[/FONT]
[FONT='Arial','sans-serif'][/FONT]
[FONT='Arial','sans-serif']The new schema name should become dbo. Next you can throw away the bmssa user.  Finally you recreate the bmssa user on the highest level on the database and set the default schema to dbo.[/FONT]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!257.entry