[AccessD] Article on upgrading

What is the server that will host SQL Server.  This needs to be asked particularly if you are 
installing SQL Server onto the server.  Windows Server 2000 cannot support SQL Server 2008 or 
beyond.  This has to do with not supporting the .Net frameworks required.  So for Windows 2000 and 
below, SQL Server 2005 is a good as it gets.

Know that SQL Server 2008 Express is actually the 2008 R2.  This matters IF any other SQL Server 
2008 instances are running that are not 2008 R2 because the two versions are *not* compatible. 
2008R2 can handle the non-R2 files (and backups) but 2008 cannot handle R2 files and backups.

Expect to learn SQL Server security!

John W. Colby
www.ColbyConsulting.com

On 7/28/2011 12:54 PM, Susan Harkins wrote:
> I'll be writing about upgrading to SQL Server and I'd like to include as many of you in it as possible -- you'll get credit and a link -- it's a nice thing to show the boss and clients.
>
> The angle is -- questions you should ask when deciding whether to upgrade an Access database to SQL Server (Express is Okay too) -- specific to the decision-making process. Anything you think someone considering the move should evaluate before doing so -- but I'll be writing it from a "questions you should ask" perspective.
>
> It'll be interesting reading for the list too I think, so if nobody objects -- I see no reason to ask for these responses off list.
>
> Thanks!
> Susan H.