| View previous topic :: View next topic |
| Author |
Message |
chelta
Joined: 15 Jun 2010
Posts: 1
|
 Posted: Tue Jun 15, 2010 3:33 pm Post subject: Migrating Hardcat Database from SQL2000 to SQL2005/2008 |
 |
|
Hi,
I would like to find out the best procedure to migrate a Hardcat database from a MSSQL 2000 server to a MSSQL 2008 server (if possible) or to a MSSQL 2005 server. Can you please tell me the best steps?
Can you simply backup the database, restore to the new server, restore logins, etc - then repoint the DSN? Also there are alot of users who use the hardcat application - what is the best method used to update the connection to the new database server? |
|
| Back to top |
|
 |
Adam
Site Admin
Joined: 12 Sep 2007
Posts: 31
Location: Sth. Melbourne, Australia.
|
| Posted: Thu Jun 17, 2010 2:05 pm Post subject: Reply |
|
|
Hi Chelta,
Thanks for contacting the Hardcat Support forum.
| Quote: | | I would like to find out the best procedure to migrate a Hardcat database from a MSSQL 2000 server to a MSSQL 2008 server (if possible) or to a MSSQL 2005 server. Can you please tell me the best steps? |
Yes, please click on this link for info about migrating your existing database into another DBMS.
NOTE: Please ensure you have Build 700+ of Hardcat before migrating across to SQL 2005/2008. And check out our Technical Requirements Doc to ensure the selected DBMS will be supported.
| Quote: | | Can you simply backup the database, restore to the new server, restore logins, etc - then repoint the DSN? Also there are alot of users who use the hardcat application |
If you are referring to SQL Server Backup & Restore, than no. See this link for information how SQL Server tools does not complete the restore correctly.
Please use the method I had mentioned above.
I hope this information helps.
Adam |
|
| Back to top |
|
|
|
Hardcat Main Site
FAQ
Search
Register
Profile
Log in to check your private messages
Log in
