Post reply

Create a Database Project for a report server

  • November 24, 2015 at 10:34 am

    #305492

    Has someone ever used a "Database project" to move reports from report sever to Visual Studio Source control for development ? if yes how ?

  • November 24, 2015 at 5:09 pm

    #1842216

    The "Database Project" project type in Visual Studio is for database schemas (stored procedures, table definitions etc.). Your SSRS reports should be in a "Report Server Project".

    Do you have a Team Foundation Version Control/TFS server? Which version of Visual Studio do you use? Do you have "SQL Server Data Tools - BI" installed so you can see the "Report Server Project" type (under Business Intelligence) in the Visual Studio "New Project" window? If you've just got "SQL Server Data Tools" (which I think is the case from your post here), I don't think you will be able to see the "Report Server Project" type.

  • November 24, 2015 at 5:29 pm

    #1842220

    You are right everything is new except the report server. I have SSDT 2015 and TFS Online. Trying to copy all report to the new repository online.

  • November 25, 2015 at 5:08 pm

    #1842432

    Do you see the Report Server Project" type (under Business Intelligence) in the Visual Studio "New Project" window? This requires "SQL Server Data Tools - Business Intelligence" to be installed (SSDT-BI), not just SSDT.

    If you're already using a Report Server project in Visual Studio 2012/13/15 and just want to use TFS Online for source control, you should be able to right-click the solution (the root element) in the Solution Explorer pane of Visual Studio, and click "Add Solution to Source Control", select the Team Project (I don't recall how to create a new TFS project, but this would need done in TFS Online), then click "OK". You don't need (and can't use) a "Database Project" type project for SSRS reports.

    Let me know if you need help following the above steps, or if I've missed your point with my answer.

  • November 25, 2015 at 5:55 pm

    #1842436

    Thanks for your help and I have done that before but didn't exactly work, Is still giving me a lot of error about the source control and repository.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply