Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I would like to know if i can have bother SQL Server Express on my laptop, i currently have 2005 but a client runs 2008.
    Are there any major differences between the two of them.

    I use Access 2003 with a SQL Server 2005 Express backend, i have a form that uses a query which uses 2 tables. When i fill in the form it creates a record in both tables.

    Another question is, will SQL Server 2008 Express write records to both tables?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately there are differences such that you cannot run a 2008 SQL database on a 2005 installation of SQL Server. And if you copy a 2005 database to a 2008 server and attach it, the format is changed, so you can't take a backup of it and restore to the 2005 server or you can't copy the database and reattach to the 2005 server. Same issue between 2000 and 2005. I learned these things the hard way of course.
    Wendell

  3. #3
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,593
    Thanks
    5
    Thanked 1,059 Times in 928 Posts
    You should be able to run both versions at the same time. A different SQL instance should be installed with 2008. You'll just need to be careful about the databases.

    As far as differences go see SQL Server 2008 R2 Editions for the Microsoft take on new features.

    Joe
    Joe

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Thank you gents.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •