Mark01
asked on
SSRS Express 2014
I will be working with a small SQL server database and creating simple reports with a few calculations. There will be only a single user and a Windows 7 Home Premium computer with 4G RAM.
Will the default installation of SQL Server Express 2014 Advanced Services satisfy my requirements? Will I be able to design simple reports using Visual Studio Express 2013 for Windows Desktop and SQL Server Express 2014 Advanced Services? Should I install the 32 or 64 bit version?
Will the default installation of SQL Server Express 2014 Advanced Services satisfy my requirements? Will I be able to design simple reports using Visual Studio Express 2013 for Windows Desktop and SQL Server Express 2014 Advanced Services? Should I install the 32 or 64 bit version?
Yes, SQL Server Express 2014 Advanced Services should do everything you need. I'd use 64-bit if the Windows 7 machine is a 64-bit OS. 4GB should be okay for small-medium databases. You can probably skip full text search if that's an option. Note that Express is specifically for development, not production (licensing issues).
ASKER
Can you attach a SQL Server 2008 database to a SQL Server Express 2014 instance? If the answer is no, is there another way to copy a SQL Server 2008 database to a computer running SQL Server Express 2014?
I'm not sure what you mean by "attach", but you should be able to just backup the 2008 database, copy the .bak file to the new machine, and then restore it on the Express machine. You can probably also set the 2008 one as a Linked Server on the Express server, but I'm not sure.
ASKER
One more question: If I bought SQL Server Developer Edition 2014 to learn how to work with SSRS 2014, would I need to buy any other apps (Visual Studio) to design reports?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand. The only reason I am comparing the Express version with the Developer Edition is because I am going to learn how to work with the SSRS 2014. It is for self-study. No classes, no production for a job. I would prefer to save $50 and use the Express version.
I want to make sure that the Express version includes the design tools.
I just read that BIDS has been replaced by SQL Server Data Tools - Business Intelligence in vers. 2010 and later.
http://en.wikipedia.org/wiki/Business_Intelligence_Development_Studio
I want to make sure that the Express version includes the design tools.
I just read that BIDS has been replaced by SQL Server Data Tools - Business Intelligence in vers. 2010 and later.
http://en.wikipedia.org/wiki/Business_Intelligence_Development_Studio
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Russell.