Re: version/source control in datawarehouse project

first,
you can manage your SSIS, SSAS ans SSRS files under a source control system like visual source safe very easily. so, there is no issue here.

second,
you can use configuration files to store your database connections. each station need this config file located on the disk and setup for the developper env. (the config file is an xml file which can be edited by each developper to reflect the right servers names)
make sure you use a folder like c:\myproject\ssisconfig which is created exactly the same way on all desktops.
(there is other options to store and share the connections, but this one is easy to implement)

third,
for the version of the databases...
you have to create a good process to manage SQL script files to keep everybody updated correctly. for example, organize this into folders:
/Version1
/Patch1.1
/Patch1.2
....
each folder will contains SQL scripts which modify the database and each developer as to apply the patches on his own environment.
Visual Studio for Database Professional can do this for you.
But I recommend that only 1 person will be in charge of managing the database and the changes.
http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx

and finally... communicate! :-)


"YesGoGoGo" <YesGoGoGo@xxxxxxxxx> wrote in message news:1187628671.026950.145670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • version/source control in datawarehouse project
    ... and our development machine is also given by user. ... There is no server or desktop in our company. ... I think it's VERY important to have code under version control. ... When sb wants to modify the code, ...
    (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: SQLOLEDB provider internally creates multiple connections to SQL server when commands executed a
    ... becoms out of session context info on the server side. ... Is there any way to control this automatic creation of connections to ... Pooling and SQLServers propensity to create additional connections as it ... It is kind of like the old determistic basic I/O services. ...
    (microsoft.public.data.ado)
  • Re: ADO data control, proper use
    ... It is not a good idea to open multiple connections from the same ... > connections is expensive and requires additional resources from the server ... > using ANY bound controls and use ADO library directly. ... > controls, you cannot control opening of the connections and each control ...
    (microsoft.public.vb.database.ado)
  • RE: VPN Clients cant access other resources
    ... Addrseses that are not in the DHCP pool and then open RRAS - rigt click ... add the addresses that I want to allocate to connections. ... I can control assignment and limit connections other than controlling PPTP or ... and can ping and DNS resolve the RRAS server but no other server or resource ...
    (microsoft.public.windows.server.general)