Rank: Member
Joined: 5/9/2009(UTC)
Posts: 2
|
I would like to know if its possible to upgrade BVC2004 to SQL Server 2005. I am changing servers and would like to move the SQL Server as well. On the new server there is 2005 so wanted to find out if this is possible?
Also if possible anyone have instructions or suggestions from having done this before?
Thanks
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,408 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 167 time(s) in 162 post(s)
|
The database will work as-is with SQL Server 2005. We have several BVC2004 sites running this way right now. As far as instructions on moving the database from SQL Server 2000 to 2005, I would Google it. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 7/14/2004(UTC)
Posts: 254
|
This might get you started. http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1188595,00.htmlNote that no two upgrades are identical...it depends on how you've setup & configured etc. Essentially, its a back up & restore process. We've been testing BV 5.5 on SQL Server 2008, if possible particularly with the recent releases of SQL 2008 SP1, I'd skip over 2005. Backup, backup, backup. John
|
|
|
|
|
|
Rank: Member
Joined: 5/13/2009(UTC)
Posts: 1
|
Thanks guys. Got it to work. There was trick where I had to create the DB and set compatibility to SQL Server 200 before restoring the backup in SQL Server 2005.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.