all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Development/Production Environment with Visual Source Safe


Development/Production Environment with Visual Source Safe JeffW
3/10/2005 4:01:29 PM
sql server reporting services: Am new to RS. Installed it on test server and was quickly able to
generate a report with multiple datasources and even write some code to
render it directly to a PDF file. Quite a useful and efficient tool.

Now, we want to bring RS into our development environment. We have
multiple developers working on an internal web app in VS.NET that we
want to incorporate reports into. Developers use Visual Source Safe to
bring project files from the development server to their own machines
to do development and then check changes back into the development
server. Periodically, our app is release from development to
production. Pretty straightforward.

What I'm curious about is:

(1) Does SourceSafe version control the report definitions? They look
like files in VS .NET but they reside in the RS database, so I'm
uncertain.

(2) Can developers install RS on their machines for developing reports
under VS.NET while using the RS server/database on the development
server for previewing?

Thanks.

Jeff
Re: Development/Production Environment with Visual Source Safe Douglas McDowell
3/11/2005 12:19:01 AM
Answers to your questions:
1. You can (and should) check reports, report projects, report
solutions--however you want to organize it--into VSS. But it is a separate
process that you have to enforce with policy and procedure as VSS will not
reach into the report catalog (database) and handle versioning there.
2. Yes. If your developers have VS.NET 2003, then just install any version
of Reporting Services on their workstations, just unselect and server
components if they are offered in the setup.
--
Douglas McDowell douglas@nospam.solidqualitylearning.com


[quoted text, click to view]

AddThis Social Bookmark Button