|
|
|
Posts: 34
Joined: August 2010
|
|
#20127
03/27/2010 3:09 PM
|
Joined: Feb 2010
Posts: 7
Member
|
OP
Member
Joined: Feb 2010
Posts: 7 |
Does anyone know how to change the data base from SQL Express to SQL 2005 or 2008 since this may be a better option since more stable and faster. From my understanding there is a command sequence that will only attach the data base to SQL EXP 2005 which the developers only know and there is no way of moving the database to other SQL servers without this command. It may also a better choice for them to use SQL EXP 2008 wich functions with 2 CPU's and 2 GB of RAM. Any thoughts?
|
|
|
|
|
Joined: Sep 2003
Posts: 12,908 Likes: 34
Member
|
|
Member
Joined: Sep 2003
Posts: 12,908 Likes: 34 |
I have always had luck with making a backup and reinstalling AC and choosing I already have a database and attach to that instance. But it's been awhile. I do think SQL Express is a fairly robust database however.
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
Member
Joined: Nov 2006
Posts: 2,084 |
There is a parameter, but it's not secret. There are detailed instructions on upgrading from SQL Express to SQL 2005. In addition, Microsoft provides a free downloadable upgrade advisor to identify potential problems prior to upgrading to SQL Server 2008. Remember to do a backup.
John
Internal Medicine
|
|
|
|
0 members (),
317
guests, and
20
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
