difference between SQL Server 2005 and SQL Server 2008?

Question

Hi,

 

What is difference between SQL Server 2005 and SQL Server 2008?

 

If i want to migrate from 2005 to 2008 , what i need to do with my existing database. I mean to say how can i transfer my database from 2005 to 2008.

 

Thanks.

 

Regards

Kashif Chotu

 

 

Answer 1

There are many new features and enhancement in 2008 from 2005. Refer

http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

 

The migration process is pretty simple, Backup from 2005 and restore it in 2008 or you can use Dettach/attach method also. There is Copy database wizard which is a GUI tool to do migration. But best method will be backup/restore. As usual you should transfer your Server level objects like Logins, Jobs, SSIS packages sperately.

 

Madhu

Answer 2

Thanks for reply.

 

I will follow.

 

Answer 3

Hi Madhu,

I've been trying to find the answer, but have so far been unsuccessful.  Hopefully you might know.  I am running MS SQL 2005 currently and just received data from a client who runs MS SQL 2008.  Is it possible to load their 2008 data on my 2005 server?

Thanks,

Ashley

Answer 4

Unfortunately not.  You can obtain SQL 2008 Developer Edition for less than $50 though, and it won't be a concern.

---

Aaron Alton | thehobt.blogspot.com

Answer 5

No, you would not be able to use SQL Server 2008 database in SQL Server 2005. You may want to download SQL Server 2008 Express version.

BTW, here is a nice link about SQL Server 2008
http://www.angryhacker.com/blog/archive/2008/06/20/10-reasons-why-sql-server-2008-is-going-to-rock.aspx

Answer 6

Check this Link, it will explain the difference between SQL 2005 and SQL 2008

http://blogs.msdn.com/euanga/archive/2007/11/07/compression-whats-the-difference-between-sql2005-and-sql2008.aspx

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 7

Thank you all for your help.  It is very much appreciated.  

Answer 8

There's a video on the SQL Server 2008 webcasts and virtual labs site called New Features in SQL Server 2008 for Developers that might be useful. 

Answer 9

Hi,

Yes you can go with 2008 Express version.

Thanks

---

Varinder Sandhu

Answer 10

.

Answer 11

SQL SERVER 2005:

1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is introduced.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Cant encrypt
13.Can Compress tables and indexes.(Introduced in 2005 SP2)
14.Datetime is used for both date and time.
15.Varchar(max) and varbinary(max) is used.
16.No table datatype is included.
17.SSIS is started using.
18.CMS is not available.
19.PBM is not available.
20.PIVOT and UNPIVOT functions are used.

SQL SERVER 2008:

1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is used.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Can encrypt the entire database introduced in 2008.
 --check it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx)
   (http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/) 
   (http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx)
   (http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)
   (http://geekswithblogs.net/chrisfalter/archive/2008/05/08/encrypt-documents-with-sql-server.aspx)
13.Can compress tables and indexes.
 -http://www.mssqltips.com/tip.asp?tip=1582
14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone
 is used.
15.Varchar(max) and varbinary(max) is used.
16.Table datatype introduced.
17.SSIS avails in this version.
18.Central Management Server(CMS) is Introduced.
 -http://msdn.microsoft.com/en-us/library/bb934126.aspx
 -http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx
19.Policy based management(PBM) server is Introduced.
 -http://www.mssqltips.com/tip.asp?tip=1492
 -http://msdn.microsoft.com/en-us/library/bb510667.aspx
20.PIVOT and UNPIVOT functions are used.
 -http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

--Never quit in ur life - SATHISH->NS