|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/16/2008 6:22:02 AM
Posts: 4,
Visits: 6
|
|
Hi,
We're currently running the Ayanova DB on sql2000.
Is it possible to migrate the database to SQL2005 Express edition?
Are there any known issues regarding the migration?
hope
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190,
Visits: 5,029
|
|
| Hi With SQL you can always go "up" - you just cannot go back to an older version. My suggestion would be the following : - Ensure everyone is out of AyaNova and any other AyaNova related programs are shut down
- Make a backup of AyaNova on the SQL2000
- On the SQL 2005 server, restore the AyaNova SQL 2000 database
- Edit your AyaNova configuration file as needed to reflect the new server (i.e. if AyaNova 4, this would be the config.txt; if AyaNova 3 this would be the AyaNova.exe.config)
- Log in and confirm connecting correctly
- If AyaNova is networked, ensure all other AyaNova users configuration file is replaced
- Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/16/2008 6:22:02 AM
Posts: 4,
Visits: 6
|
|
Hi,
Thank you for the fast and detailed reply!
We will schedule this migration soon!
again thank you! and keep it up!
|
|
|
|
Posted 1/16/2008 4:14:39 AM
