SQL 2008 Shared Database

  • Thread starter Thread starter Brad Covell
  • Start date Start date
B

Brad Covell

We are using a SQL Enterprise 2005 shared database with 4 users. Each user has SQL 2005 Express installed (the version that installs with BCM). We would like to upgrade the shared database to SQL 2008. Is this supported?

Do the users need to update to 2008 Express or can they continue to use 2005?

Thanks
Brad
officepoint.blogspot.com
 
We are using a SQL Enterprise 2005 shared database with 4 users. Each user has SQL 2005 Express installed (the version that installs with BCM). We would like to upgrade the shared database to SQL 2008. Is this supported?

Do the users need to update to 2008 Express or can they continue to use 2005?

Thanks
Brad
officepoint.blogspot.com
Click to expand...

Technically it should work - BCM tends to use simple SQL which doesn't
change between sql releases.

However, Sql keeps uping the security, so you may need to tweak the
database's security settings after upgrading.
 
Yes / no. We have never tested BCM 2007 with SQL Server 2008. It probably
should work as Luther has stated, but I cannot make any guarentee to you that
your daily operations will not get interrupted.

Before doing anything, please backup or export all of your data to be safe.
Tweaks / security and permission changes are almost certainly a requirement
on your side if you decide to make the move.
 
Thanks for the information. Based on what you described and some of our
users already being wary of continuing with BCM, I think we will wait.

Brad

John Huang said:
Yes / no. We have never tested BCM 2007 with SQL Server 2008. It
probably
should work as Luther has stated, but I cannot make any guarentee to you
that
your daily operations will not get interrupted.

Before doing anything, please backup or export all of your data to be
safe.
Tweaks / security and permission changes are almost certainly a
requirement
on your side if you decide to make the move.
--
John Huang [MSFT]

This posting is provided "AS IS" with no warranties, and confers no
rights.



Luther said:
Technically it should work - BCM tends to use simple SQL which doesn't
change between sql releases.

However, Sql keeps uping the security, so you may need to tweak the
database's security settings after upgrading.
Click to expand...
Click to expand...
 
Thank you, Bard, for getting back to me and letting me know of your decision.
If there is anything else that we can do, please don't hesitate to post it
here.
--
John Huang [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.



Brad Covell said:
Thanks for the information. Based on what you described and some of our
users already being wary of continuing with BCM, I think we will wait.

Brad

John Huang said:
Yes / no. We have never tested BCM 2007 with SQL Server 2008. It
probably
should work as Luther has stated, but I cannot make any guarentee to you
that
your daily operations will not get interrupted.

Before doing anything, please backup or export all of your data to be
safe.
Tweaks / security and permission changes are almost certainly a
requirement
on your side if you decide to make the move.
--
John Huang [MSFT]

This posting is provided "AS IS" with no warranties, and confers no
rights.



Luther said:
We are using a SQL Enterprise 2005 shared database with 4 users. Each
user has SQL 2005 Express installed (the version that installs with
BCM). We would like to upgrade the shared database to SQL 2008. Is this
supported?

Do the users need to update to 2008 Express or can they continue to use
2005?

Thanks
Brad
officepoint.blogspot.com

Technically it should work - BCM tends to use simple SQL which doesn't
change between sql releases.

However, Sql keeps uping the security, so you may need to tweak the
database's security settings after upgrading.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top