Data migration SQL

Angelo

May I just use attach and detach database Nav for migration SQL from sql standard edition to enterprise edition?

rgds,
Angelo

kine

Yes, but do not forget to migrate users too (I assume that detach/attach is not working with master database...) :-)

And I am not sure, but may be there is some "upgrade path" to install Ent. version over standard one...

Angelo

Kine,

so, what the normal we have to do for migrating sql version if using attach/detach database is not good? backup and restore? backup from navision or sql?

Pls advice....

rgds,
Angelo

kine

I am not saying "it is not good". It is good and common, but you need to think about all the data which are in master DB and it means to migrate the users somehow too... and which version of SQL you are using/you will be using? SQL 2005 has tools for migrating users.

You can read more in the MS SQL documentation under topic "upgrading SQL Server" (for SQL 2005) and "upgrading SQL Server, edition upgrades" (for SQL 2000). In the supported scenarios the upgrade process will do everything for you and you do not need to detach/attach the databases.

bbrown

If you are upgrading the same server, you can simply install the Enterprise Edditon right on top of the Standard Edition.

Angelo

bbrow,
Yes, still in same server.
Do you mean I shouldn't remove old edition of sql and just install enterprise edition directly?

idiot

The tried & tested way
1. Use a script to export all the users out
2. Detach database
3. Uninstall SQL server
4. Install SQL server & apply patch
5. Use a script to import previously exported users
6. Attach database
7. Synchronise

bbrown

There is no difference in the database between standard and entreprise editions. You do not need to detach and re-attach them.

kriki

[Topic moved from Navision forum to SQL General forum]