Re: version/source control in datawarehouse project

thanks to Jeje
your advice is very useful for me!

I've tried to build an environment like what you mention
but there is still a problem about connection configuration.

the following is my SSIS project file
DTS_MIGRATE
AC
BACKUP
DataSource
DOWNLOAD
DP
FD
LN
OTHER
I gather all datasources(*.ds) in DataSource folder and put *.dtsx
into their corresponding folders
So if the db connection on developer's machine is different from
server's
All he has to do is modify *.ds, right?
But I've found in every *.dtsx
db connection is also written in dtsx, like <DTS:Property
DTS:Name="ConnectionString">Data Source=localhost;Initial
Catalog=DW;Provider=SQLNCLI.1;Integrated Security=SSPI;</DTS:Property>
that means developer has to modify all conn string in all dtsx....
that's so frustrating...
Can't I just modify one place(*.ds) and make all dtsx work?

there's another question about edting xml
If I use ultraedit to modify *.ds db connection, although the xml has
changed and saved
After I open the project,these connecitons don't work
I still have to modify these conn in IDE environment

Maybe I'm not familiar to SSIS.

still need help!
thanks a lot!


On 8 21 , 8 16 , "Jeje" <willg...@xxxxxxxxxxx> wrote:
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" <YesGoG...@xxxxxxxxx> wrote in message

news:1187628671.026950.145670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


.

Relevant Pages

  • Re: Connection string issue when in a separate web.config
    ... Dominick Baier - DevelopMentor ... permissions for the Secure folder. ... the indexer on .ConnectionStrings expects the name of the connection ... Configuration c = ...
    (microsoft.public.dotnet.security)
  • Windows Firewall with RAS (incoming connection)
    ... address on the LAN card and the Remote Desktop ... Connection to the SERVER can be established using that address. ... Windows IP Configuration ... Service configuration for Standard profile: ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Big hole??
    ... > firewall then even they can't get in, ... > supposedly safe SP2 for Windows XP invites any Internet ... > Connection Sharing of the PC has to be disabled. ... > in fact is a common configuration and not a rare sight. ...
    (microsoft.public.windowsxp.general)
  • Re: Remote Access and Outlook Web Access on SBS 2003
    ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... network, firewall, secure Web site, and e-mail. ... NETWORKING CONFIGURATION SUMMARY ...
    (microsoft.public.windows.server.sbs)
  • Re: wireless and router; security issue
    ... issues like yours (and allow configuration with AD group policy). ... and the filesharing service of my network connection. ... The firewall I have is McAfee firewall 7.x, ...
    (microsoft.public.security)