Migration database from SQL Enterprise version to SQL development / express version

Question

One of our team is working on migration TFS database from external vendor into client's environment. 

Source version is SQL 2008 Enterprise edition.

In one case destination is SQL 2012 Standard edition and in another case it is SQL 2012 Express.

I looked at this blog, this might solve issue related to migration.

But what my concern is, difference between Enterprise/Standard/Express is only about data compression , no other differences / impact in migration?

---

Technical Project Manager cum Architect

Answer 1

Hi,

here is a great blog post about this: http://nakedalm.com/restore-tfs-backups-from-sql-enterprise-to-sql-express/

You can find limitations of SQL Express on the following page: https://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

1) Maximum memory utilized  - 1 GB

2) Maximum relational Database size - 10 GB
3) Limited to lesser of 1 Socket or 4 cores
4) Full-text search is not supported

Thanks,

--Vladimir

Answer 2

Hello Vladimir,

Thanks for your reply.

Still i have 2 questions

• So you mean other than compression feature there is no difference when it comes to different version of SQL server ?
• So if we use SQL server for other than TFS then also difference is only about compression?

Of course limitation on size, memory is there.

---

Technical Project Manager cum Architect

Answer 3

Hi Manish,

Thanks for your post.

SQL Server Express support the Basic configuration of TFS Server.

What’s the version of your TFS Server? You need ensure the SQL Server version support the TFS version first, if you’re using TFS 2013, for which version of SQL Server support TFS 2013, please refer to the information in this document: https://msdn.microsoft.com/en-us/library/dd631889(v=vs.120).aspx.

For the what’s the detailed feature differences between different SQL Server versions, please contact SQL Server experts for the better response.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey.