4 Replies - 795 Views - Last Post: 27 November 2012 - 10:04 PM Rate Topic: -----

#1 newb1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 07-November 09

SQLserver version importance

Posted 25 November 2012 - 01:26 PM

Hi,
I want to try out an SQLserver Express database (replacing an Access database). Is the version (SQLserver Express 2005 / 2008 etc.) important. I have version 2005 & I'd like to try it out on a website. do i need to check with the hosting site. Does this issue need to be taken care of whenever we make a project using SQLserver Express database. Is there something like backward/forward compatibility wherein one version would work with all sites irrespective of the version supported by the site. For example, if a site says that it provides version 2008, then it would automatically support 2005. or the other way round.

TIA,
milind.

Is This A Good Question/Topic? 0
  • +

Replies To: SQLserver version importance

#2 trevster344  Icon User is offline

  • The Peasant
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,511
  • Joined: 16-March 11

Re: SQLserver version importance

Posted 27 November 2012 - 09:53 AM

I'm really not sure of the technicalities. I installed SQLServer 2008 on my web server, and soon moved over to 2012 R2. My database didn't change, but it still worked the same no problem. Actually with the 2012 R2 I had no problems.. 2008 wouldn't work with my windows server 2003 for some reason.
Was This Post Helpful? 1
  • +
  • -

#3 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9570
  • View blog
  • Posts: 36,240
  • Joined: 12-June 08

Re: SQLserver version importance

Posted 27 November 2012 - 09:54 AM

Outside of a small number of commands being depreciated - no, your TSQL statements should not be affected by various versions of MSSQL.
Was This Post Helpful? 1
  • +
  • -

#4 newb1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 07-November 09

Re: SQLserver version importance

Posted 27 November 2012 - 11:07 AM

thanks @trevster344 and @modi123_1
Was This Post Helpful? 0
  • +
  • -

#5 trevster344  Icon User is offline

  • The Peasant
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,511
  • Joined: 16-March 11

Re: SQLserver version importance

Posted 27 November 2012 - 10:04 PM

You're welcome sir. Also thanks modi for the info.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1