version/source control in datawarehouse project

Hi!
I'm a freshman in a datawarehouse company.
All my coworkers are on-site in user side,such as banks,
and our development machine is also given by user.
There is no server or desktop in our company.
After I join this company,I find there's no version/source control in
our company's projects.
Because I used to work in a web-based system development company,
I think it's VERY important to have code under version control.

In my new company,there are 1~3 members in each project.
Everyone of them will terminal to server,open the same project and
modify it.
I try to think if there is a better way to improve this develop cycle.
First of all,I have to have a version control server,such as
subversion.
Because we don't have a server in our company
,maybe installing SVN on development server is a good way.
When sb wants to modify the code(SSIS/SSRS),
he has to update his working copy to the latest version and modify it.

But for me,there is a problem
take SSIS for instance, how do we design datasource connectiion to
make it available for every developer?
if datasource is DB connection,I can change "localhost" to servername
or ip to ensure connections on everyone's computer works.
but for development server,would using servername instead of
"localhost" make db connection lower?because it has to parse the
servername? this is my first convern.

If datasource is file connection,there is a similar situation,using
relative path could make the code fit everyone's working environment
but maybe inefficient when reading file?

In the begining,I think maybe we can copy DB or files to developer's
machine, but I find DB and files are too large(too much data...)

And there are many abosolute path in our code
So if I want to bring version/source control into this project,it
seems we have to modify those path.

After ETL,we have SSAS,SSRS to do.
I want to know if there is a better way or best practice to design the
version control of the datawarehouse project?
For me,it seems like a mess now...

Need some advice
Thanks a lot!!

.

Relevant Pages

  • Re: version/source control in datawarehouse project
    ... SSAS ans SSRS files under a source control system like visual source safe very easily. ... you can use configuration files to store your database connections. ... each folder will contains SQL scripts which modify the database and each developer as to apply the patches on his own environment. ... There is no server or desktop in our company. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: How to hide directories?
    ... I don't like to give anyone but system/admins full control - for all users, ... modify is quite enough. ... > I have just started an SBS server. ... I moved the folder where users home direktory are ...
    (microsoft.public.windows.server.sbs)
  • Re: Working with hidden input controls and Visual Studio .Net 2003
    ... there's a way to automate this with VS (like adding any other control), and if not if I was putting that information in the correct place on the code behind page. ... But, if you don't need javascript to modify the value and you just want it passed back to the server on a post, the view state is far easier. ...
    (microsoft.public.dotnet.framework.aspnet)
  • remote control over water pump
    ... how do I from 2700 km control such IBM thinkpad? ... is there a simple server to correct and modify any file in that IBM ...
    (sci.electronics.design)
  • Asp.net Important Topics.
    ... ASP.NET server controls contained within the page. ... A custom server control is ... can also perform validation using client script. ... Where does the Web page belong in the .NET Framework class hierarchy? ...
    (microsoft.public.dotnet.framework.aspnet)