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?
Mark01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
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).
0
Mark01Author Commented:
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?
0
Russell FoxDatabase DeveloperCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mark01Author Commented:
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?
0
Russell FoxDatabase DeveloperCommented:
No, you would just need to get the free BIDS (Business Intelligence Development Studio) which is a specialized version of Visual Studio. I love the developer edition because it gives you everything that's in the enterprise edition, but be forewarned: you shouldn't use it in production and you shouldn't create solutions that rely on enterprise-only features if your company can't afford the enterprise edition when you go live (data-driven subscriptions, change data capture, data compression, etc.). I'm stuck with standard edition at my job, so I have to be extra careful.
0
Mark01Author Commented:
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
0
Russell FoxDatabase DeveloperCommented:
Gotcha, then I think you'll be fine with Express. If you find you want to learn some more advanced features, you can always upgrade it later with the developer edition. If you're focusing on reporting, the only major difference will be data-driven subscriptions, but that's pretty easy, so I don't think you'll need to practice it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark01Author Commented:
Thank you, Russell.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.