?
Solved

SSRS Express 2014

Posted on 2014-07-28
8
Medium Priority
?
770 Views
Last Modified: 2014-07-30
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?
0
Comment
Question by:Mark01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40225324
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
 

Author Comment

by:Mark01
ID: 40225587
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
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40225666
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:Mark01
ID: 40225714
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
 
LVL 13

Assisted Solution

by:Russell Fox
Russell Fox earned 2000 total points
ID: 40225736
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
 

Author Comment

by:Mark01
ID: 40225802
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
 
LVL 13

Accepted Solution

by:
Russell Fox earned 2000 total points
ID: 40225814
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
 

Author Comment

by:Mark01
ID: 40230952
Thank you, Russell.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question