use of SQL server express

Question

In my work environment, I need to use SQL server express software to download or transfer from another server (which operates SQL Management Studio 2014) sequel tables/views to my local server.  Is SQL server express completely compatible for thransfer of data which was originally set up in SQL Management studio 2014?  Are there any differences that I need to take into account?

After transferring the data, it will be imported into statistical software such as SAS or SPSS.

Thanks

Answer 1

You might be better pushing the data from your source SQL Server instance into SQL Server Express.

The version of SQL Server Express will also need to be taken into consideration due to the restrictions of the database size.  E.g. 2000 Version is limited to 2Gb whereas 2012 is limited to 10Gb.

Also for your SQL Express database ensure the recovery mode is set to Simple.

---

Please click "Mark As Answer" if my post helped. Tony C.

Answer 2

You can use import export wizard is express edition to transfer data. You can see features supported by Express edition

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP