Forgive my ignorance as this may be a stupid noob question - I'm originally a front-ender who's been given Umbraco duties (-:
At the beginning of your brief the instructions say to provide 5 parameters. This is fine except for the last one - OLEDB. The example in the .build file is
Why do I need to provide this? I'm sure there is a good reason but later in the build script, it is clever enough to retrieve the 'umbracoDbDSN' key value from the relevant site's web.config.
Should I be converting my current connection string (in the place just described) into a new format for OLEDB? Where will the login credentials go? I've tried substituting what I thought would be the relevant lines into your example OLEDB parameter but as soon as I run the Nant script, it fails when attempting to create a .bak file from the site's DB.
I'm really keen to get this script running as I have been experimenting lately with implementing a continuous integration server (i.e. Jenkins) into our agency infrastructure and being able to take and restore snapshots of sites like this (as well as automating it) would be phenomally useful!
Nevermind - it turned out to be something completely different. I was trying to use this script locally and the umbraco database is on a remote machine. The line:
Falling at the first hurdle :/
Forgive my ignorance as this may be a stupid noob question - I'm originally a front-ender who's been given Umbraco duties (-:
At the beginning of your brief the instructions say to provide 5 parameters. This is fine except for the last one - OLEDB. The example in the .build file is
Provider=SQLOLEDB;Data Source=localhost; Initial Catalog=master; Integrated Security=SSPI
Why do I need to provide this? I'm sure there is a good reason but later in the build script, it is clever enough to retrieve the 'umbracoDbDSN' key value from the relevant site's web.config.
Should I be converting my current connection string (in the place just described) into a new format for OLEDB? Where will the login credentials go? I've tried substituting what I thought would be the relevant lines into your example OLEDB parameter but as soon as I run the Nant script, it fails when attempting to create a .bak file from the site's DB.
I'm really keen to get this script running as I have been experimenting lately with implementing a continuous integration server (i.e. Jenkins) into our agency infrastructure and being able to take and restore snapshots of sites like this (as well as automating it) would be phenomally useful!
Thanks in advance,
Giles
Nevermind - it turned out to be something completely different. I was trying to use this script locally and the umbraco database is on a remote machine. The line:
<property name="sql.data.dir" value="C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA"/>
is completely different to my local storage so I need to setup a network drive share or something so that the 2 drive structures are in sync!
is working on a reply...