Running scripts after database create

165 views
Skip to first unread message

Tim Shepherd

unread,
Dec 18, 2012, 8:25:20 AM12/18/12
to chucknorri...@googlegroups.com
Hi All
 
I'm trying to use Roundhouse 0.8.5 with the console. I've got a BAT file that is launching rh.exe and doing a /drop first, the re-creates the database using the /simple switch. What I can't see happening is the scripts running in the "runaftercreatedatabasefolder". The database dropping and creation run ok, and I can see it going through the other script folders in the right order - is there something I'm missing (I've based my bat on the samples from the zip I downloaded).
 
Here's my bat (I've condensed the rh.exe setting for space)
 
@echo off
SET DIR=%~d0%~p0%
 
SET database.name="DEV_AcademyCore"
SET sql.files.directory=%DIR%..\
SET server.database="MSSQLSERVER2008"
SET repository.path="https://svn/DatabaseSchema"
SET version.file="_BuildInfo.xml"
SET version.xpath="//buildInfo/version"
SET environment="LOCAL"
SET folder.dbcreate=%sql.files.directory%0001_CreateDatabase\custom_db_create.sql
SET folder.dbalterfolder=%sql.files.directory%0002_AlterDatabase\
SET folder.runaftercreate=%sql.files.directory%0003_RunOnceAfterCreate\
SET folder.upfolder=%sql.files.directory%0004_RunOnceUpdates\
SET folder.runfirst=%sql.files.directory%0005_RunFirstAfterUpdate\
SET folder.functions=%sql.files.directory%0006_Functions\
SET folder.views=%sql.files.directory%0007_Views\
SET folder.sprocs=%sql.files.directory%0008_StoredProcedures\
SET folder.runafteranyother=%sql.files.directory%0009_RunAnytime\
SET folder.permissions=%sql.files.directory%0010_PermissionRunEverytime\
 
rem - the drop 
"%DIR%Console\rh.exe" 	/d=%database.name% 
			/f=%sql.files.directory% 
			/s=%server.database% 
			/vf=%version.file% 
			/vx=%version.xpath% 
			/r=%repository.path% 
			/env=%environment% 
			/createdatabasescript=%folder.dbcreate% 
			/upfolder=%folder.upfolder% 
			/runfirstfolder=%folder.runfirst%  
			/functionsfolder=%folder.functions% 
			/viewsfolder=%folder.views% 
			/sprocfolder=%folder.sprocs% 
			/runAfterOtherAnyTimeScripts=%folder.runafteranyother% 
			/permissionsfolder=%folder.permissions% 
			/alterdatabasefolder=%folder.dbalterfolder% 
			/runaftercreatedatabasefolder=%folder.runaftercreate% 
			/drop

 
rem - recreate  
"%DIR%Console\rh.exe" 	/d=%database.name% 
			/f=%sql.files.directory% 
			/s=%server.database% 
			/vf=%version.file% 
			/vx=%version.xpath% 
			/r=%repository.path% 
			/env=%environment% 
			/createdatabasescript=%folder.dbcreate% 
			/upfolder=%folder.upfolder% 
			/runfirstfolder=%folder.runfirst%  
			/functionsfolder=%folder.functions% 
			/viewsfolder=%folder.views% 
			/sprocfolder=%folder.sprocs% 
			/runAfterOtherAnyTimeScripts=%folder.runafteranyother% 
			/permissionsfolder=%folder.permissions% 
			/alterdatabasefolder=%folder.dbalterfolder% 
			/runaftercreatedatabasefolder=%folder.runaftercreate% 
			/simple

Rob Reynolds

unread,
Dec 18, 2012, 8:44:34 AM12/18/12
to chucknorri...@googlegroups.com
Your drop doesn't need all of those folders... just the db/server or connection string and the drop.

Take a look at your sql.files.directory - notice how you set that to /f . But then that is repeated for every folder, which should be relative to the sql files directory. This may or may not have something to do with your issue, but all of the folder directories only need the name of the directory, not the path. Clean that up first and let me know if you are still seeing issues. I've provided one as an example.

SET folder.dbalterfolder=%sql.files.directory%0002_AlterDatabase\
SET folder.dbalterfolder=0002_AlterDatabase



--
You received this message because you are subscribed to the Google Groups "chucknorris" group.
To view this discussion on the web visit https://groups.google.com/d/msg/chucknorrisframework/-/FUJoowjCfhoJ.
To post to this group, send email to chucknorri...@googlegroups.com.
To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chucknorrisframework?hl=en.

Tim Shepherd

unread,
Jan 2, 2013, 1:31:13 AM1/2/13
to chucknorri...@googlegroups.com

Hi Rob

 

I've finally gotten around to cleaning up the foldernames, etc that you highlighted earlier but I am still getting the same issue as before: the scripts in the "runaftercreatedatabasefolder" do no appear to be run by the rh.exe.

 

Here's the batchfile now as it stands:

 
@echo off
CLS
 
SET DIR=%~d0%~p0%
 
SET folder.outputPath=%DIR%..\_migrations\
 
SET db.serverInstance=MSSQLSERVER2008
SET db.name=DEV_Test
 
SET db.admin.connectString="Password=c1rrus2013;User ID=rhDeployUser;Initial Catalog=master;Data Source=%db.serverInstance%;Packet Size=4096"
 
SET db.create.script=%DIR%..\0001_CreateDatabase\cirrus_db_create.sql
 
SET repository.path=https://localhost/DatabaseSchema
SET version.file=_BuildInfo.xml
SET version.xpath=//buildInfo/version
SET rh.environment=LOCAL
SET folder.scripts.base=%DIR%..\
SET folder.scripts.dbalterfolder=0002_AlterDatabase
SET folder.scripts.runaftercreate=0003_RunOnceAfterCreate
SET folder.scripts.upfolder=0004_RunOnceUpdates
SET folder.scripts.runfirst=0005_RunFirstAfterUpdate
SET folder.scripts.functions=0006_Functions
SET folder.scripts.views=0007_Views
SET folder.scripts.sprocs=0008_StoredProcedures
SET folder.scripts.runafteranyother=0009_RunAnytime
SET folder.scripts.permissions=0010_PermissionRunEverytime
 
REM --- the drop
"%DIR%Console\rh.exe" /output=%folder.outputPath% /d=%db.name% /s=%db.serverInstance% /f=%folder.scripts.base% /drop
REM --- the create
"%DIR%Console\rh.exe"  /connstringadmin=%db.admin.connectString% /output=%folder.outputPath% /d=%db.name% /s=%db.serverInstance%    /vf=%version.file% /vx=%version.xpath% /r=%repository.path% /env=%rh.environment% /f=%folder.scripts.base%    /createdatabasescript=%db.create.script% /upfolder=%folder.scripts.upfolder% /runfirstfolder=%folder.scripts.runfirst%     /functionsfolder=%folder.scripts.functions% /viewsfolder=%folder.scripts.views% /sprocfolder=%folder.scripts.sprocs%    /runAfterOtherAnyTimeScripts=%folder.scripts.runafteranyother% /permissionsfolder=%folder.scripts.permissions%    /alterdatabasefolder=%folder.scripts.dbalterfolder% /runaftercreatedatabasefolder=%folder.scripts.runaftercreate% /simple

 

I've attached the change.log that was generated when I last ran the bat file. You'll see that rh appears to look at the ..\0002_AlterDatabase folder, then the ..\0004_RunOnceUpdates, skipping the 0003_RunOnceAfterCreate folder. The error that you see logged near the end is because the tblChain object gets created by a script that is in the 0003 folder.

 

Clarification: for the drop, I tried using a full connection string with the /cs switch however rh.exe would give me back a message that it required a database name for the /d switch or a connection for the /cs switchs. The doco says that both those switches are required, however you implied that I just needed the connectionstring and the /drop but I'm not sure that rh.exe is working that way. I CAN get rh to work using the database name/server name combination.

 

Thanking you muchly for your help - I'm a bit of a noob with this :S

 

Tim

To unsubscribe from this group, send email to chucknorrisframework+unsub...@googlegroups.com.

Tim Shepherd

unread,
Jan 2, 2013, 1:34:03 AM1/2/13
to chucknorri...@googlegroups.com
Here's the change log file

On Wednesday, December 19, 2012 12:44:34 AM UTC+11, ferven...@gmail.com wrote:
roundhouse.changes.txt

Rob Reynolds

unread,
Jan 2, 2013, 6:54:55 AM1/2/13
to chucknorri...@googlegroups.com
Tim,
 I believe you may want to change your password. This is a public group and has a searchable archive on the internet.


To view this discussion on the web visit https://groups.google.com/d/msg/chucknorrisframework/-/WTiFHISg-WwJ.

To post to this group, send email to chucknorri...@googlegroups.com.
To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.

Rob Reynolds

unread,
Jan 2, 2013, 7:20:05 AM1/2/13
to chucknorri...@googlegroups.com
I did some research to see if we had an issue reported with run after create. It's due to you using a custom database create script. You would need to signal success in some way. But even then, it may not fully be compatible with v0.8.5. We have this fix going into the next version: https://github.com/chucknorris/roundhouse/pull/45 | https://github.com/chucknorris/roundhouse/issues/44

The run after create folder is used for when you have an existing database you are trying to bring on with roundhouse (existing in the sense that deleting data would be dangerous for your job ;)). If you do not have a production version of the database and you are just trying to create a new database, you might want to have those scripts in the up folder. That's the intended location of the run once type scripts (DDL/DML).

If you have a backup of production database somewhere and it is small enough (and accessible), it is preferable if you use the restore parts of the configuration. Otherwise you get into cases where it starts to make more sense to use the run after create folder.  

Up folder
  • the default location for all scripts that should run one time only
  • DDL - table creation, alter, etc
  • DML - insert, update, delete, etc
Run after create folder
  • Used to supplement up folder when it starts to get too big (as in move scripts from up to here)
  • Used for scripts that can not be run against an existing production database but should be run for newly created databases that are catching up
____
On Wed, Jan 2, 2013 at 12:31 AM, Tim Shepherd <tumbl...@gmail.com> wrote:

Hi Rob

 

I've finally gotten around to cleaning up the foldernames, etc that you highlighted earlier but I am still getting the same issue as before: the scripts in the "runaftercreatedatabasefolder" do no appear to be run by the rh.exe.

 

Here's the batchfile now as it stands:

 
@echo off
CLS
 
SET DIR=%~d0%~p0%
 
SET folder.outputPath=%DIR%..\_migrations\
 
SET db.serverInstance=MSSQLSERVER2008
SET db.name=DEV_Test
 


To post to this group, send email to chucknorri...@googlegroups.com.
To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.

Bryan Johns

unread,
Jan 2, 2013, 7:22:39 AM1/2/13
to chucknorri...@googlegroups.com
In addition to the password, I noticed this, which might not be the
problem. However, lots of times the simple fixes are the easiest to
overlook.

He said that the scripts in the "runaftercreatedatabasefolder" in quotes
just like that, are not being run. However, there is no folder by that
exact name referenced in the script. I also noticed the some of the
folder names he does reference have numeric prefixes. What is the purpose
of those prefixes? AFAIK, RH doesn't have any way to change the ordering
of the folders like it does with actual script names.

--
Bryan Johns
K4GDW
bjo...@greendragonweb.com
http://www.greendragonweb.com

"If ye love wealth better than liberty, the tranquility of servitude than
the animating contest of freedom, go from us in peace. We ask not your
counsels or arms. Crouch down and lick the hands which feed you. May your
chains sit lightly upon you, and may posterity forget that ye were our
countrymen!" --Samuel Adams
> <https://groups.google.com/d/msg/chucknorrisframework/-/FUJoowjCfhoJ> .
>
> To post to this group, send email to
> chucknorri...@googlegroups.com.
>
> To unsubscribe from this group, send email to
> chucknorrisframe...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/chucknorrisframework?hl=en
> <http://groups.google.com/group/chucknorrisframework?hl=en> .
>
>
>
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "chucknorris" group.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msg/chucknorrisframework/-/WTiFHISg-WwJ.
>
> To post to this group, send email to
> chucknorri...@googlegroups.com.
> To unsubscribe from this group, send email to
> chucknorrisframe...@googlegroups.com
> <mailto:chucknorrisframework%2Bunsu...@googlegroups.com> .
> For more options, visit this group at
> http://groups.google.com/group/chucknorrisframework?hl=en.
>
>
>
> --
> You received this message because you are subscribed to the Google
Groups
> "chucknorris" group.

Tim Shepherd

unread,
Jan 2, 2013, 5:13:36 PM1/2/13
to chucknorri...@googlegroups.com
oops - thought I'd changed all the sensitive stuff. That password is only available on my PC here I've changed it nonetheless.

Rob Reynolds

unread,
Jan 2, 2013, 5:14:23 PM1/2/13
to chucknorri...@googlegroups.com
You saw the answer hiding in here as well right? :D



Tim Shepherd

unread,
Jan 2, 2013, 6:44:51 PM1/2/13
to chucknorris
There are copies of my post quoted all over this thread - it also
makes reading it a bit hard!

Anyway

Rob, I understand what you are saying about using the up folder and
the intended purpose of the "runaftercreatedatabase" folder - you may
want to make the distinction clear in doco for the complete noobs :)

To give you a clearer picture, I have a in-house framework that
requires the database to have a minimum set of tables and data in
order to run. We then build our applications on top of the framework
and during the course of that development, we'd add more tables,
sprocs, data, etc, etc. So in "my world", a "new database" isnt just
CREATE DATABASE, it's CREATE DATABASE and then create a whole lot of
objects to get the framework into a run-able state (I'm sure that's a
familiar development senario these days). I had thought that I could
use the "runaftercreatedatabase" folder to do the creation of the
required framework objects and the up folder would contain the various
scripts that would create/modify application-specific objects.

I had a look at the pull request regarding the return value from the
custom create script - when would that look like being released?

Tim


On Jan 2, 7:20 am, Rob Reynolds <ferventco...@gmail.com> wrote:
> I did some research to see if we had an issue reported with run after
> create. It's due to you using a custom database create script. You would
> need to signal success in some way. But even then, it may not fully be
> compatible with v0.8.5. We have this fix going into the next version:https://github.com/chucknorris/roundhouse/pull/45|https://github.com/chucknorris/roundhouse/issues/44
>
> The run after create folder is used for when you have an existing database
> you are trying to bring on with roundhouse (existing in the sense that
> deleting data would be dangerous for your job ;)). If you do not have a
> production version of the database and you are just trying to create a new
> database, you might want to have those scripts in the up folder. That's the
> intended location of the run once type scripts (DDL/DML).
>
> If you have a backup of production database somewhere and it is small
> enough (and accessible), it is preferable if you use the restore parts of
> the configuration. Otherwise you get into cases where it starts to make
> more sense to use the run after create folder.
>
> Up folder
>
>    - the default location for all scripts that should run one time only
>    - DDL - table creation, alter, etc
>    - DML - insert, update, delete, etc
>
> Run after create folder
>
>    - Used to supplement up folder when it starts to get too big (as in move
>    scripts from up to here)
>    - Used for scripts that can not be run against an existing production
>    database but should be run for newly created databases that are catching up
>
> ____
> Rob
> "Be passionate in all you do"
>
> http://devlicio.us/blogs/rob_reynoldshttp://ferventcoder.comhttp://twitter.com/ferventcoder
> >> SET folder.dbalterfolder=%sql.**files.directory%0002_**AlterDatabase\
>
> >> SET folder.dbalterfolder=0002_**AlterDatabase
>
> >> ____
> >> Rob
> >> "Be passionate in all you do"
>
> >>http://devlicio.us/blogs/rob_**reynolds<http://devlicio.us/blogs/rob_reynolds>
> >>http://ferventcoder.com
> >>http://twitter.com/**ferventcoder<http://twitter.com/ferventcoder>
>
> >> On Tue, Dec 18, 2012 at 7:25 AM, Tim Shepherd <tumbl...@gmail.com> wrote:
>
> >>> Hi All
>
> >>> I'm trying to use Roundhouse 0.8.5 with the console. I've got a BAT file
> >>> that is launching rh.exe and doing a /drop first, the re-creates the
> >>> database using the /simple switch. What I can't see happening is the
> >>> scripts running in the "runaftercreatedatabasefolder"**. The database
> >>> dropping and creation run ok, and I can see it going through the other
> >>> script folders in the right order - is there something I'm missing (I've
> >>> based my bat on the samples from the zip I downloaded).
>
> >>> Here's my bat (I've condensed the rh.exe setting for space)
>
> >>> @echo off
> >>> SET DIR=%~d0%~p0%
>
> >>> SET database.name="DEV_**AcademyCore"
> >>> SET sql.files.directory=%DIR%.**.\
> >>> SET server.database="**MSSQLSERVER2008"
> >>> SET repository.path="https://**svn/DatabaseSchema <https://svn/DatabaseSchema>"
> >>> SET version.file="_BuildInfo.**xml"
> >>> SET version.xpath="//**buildInfo/version"
> >>> SET environment="LOCAL"
> >>> SET folder.dbcreate=%sql.**files.directory%0001_**CreateDatabase\custom_db_**cr­eate.sql
> >>> SET folder.dbalterfolder=%sql.**files.directory%0002_**AlterDatabase\
> >>> SET folder.runaftercreate=%**sql.files.directory%0003_**RunOnceAfterCreate\
> >>> SET folder.upfolder=%sql.**files.directory%0004_**RunOnceUpdates\
> >>> SET folder.runfirst=%sql.**files.directory%0005_**RunFirstAfterUpdate\
> >>> SET folder.functions=%sql.**files.directory%0006_**Functions\
> >>> SET folder.views=%sql.files.**directory%0007_Views\
> >>> SET folder.sprocs=%sql.files.**directory%0008_**StoredProcedures\
> >>> SET folder.runafteranyother=%**sql.files.directory%0009_**RunAnytime\
> >>> SET folder.permissions=%sql.**files.directory%0010_**PermissionRunEverytime\
>
> >>> rem - the drop
> >>> "%DIR%Console\rh.exe"    /d=%database.name%
>
> >>>                    /f=%sql.files.directory%
>
> >>>                    /s=%server.database%
>
> >>>                    /vf=%version.file%
>
> >>>                    /vx=%version.xpath%
>
> >>>                    /r=%repository.path%
>
> >>>                    /env=%environment%
>
> >>>                    /createdatabasescript=%folder.**dbcreate%
>
> >>>                    /upfolder=%folder.upfolder%
>
> >>>                    /runfirstfolder=%folder.**runfirst%
>
> >>>                    /functionsfolder=%folder.**functions%
>
> >>>                    /viewsfolder=%folder.views%
>
> >>>                    /sprocfolder=%folder.sprocs%
>
> >>>                    /runAfterOtherAnyTimeScripts=%**folder.runafteranyother%
>
> >>>                    /permissionsfolder=%folder.**permissions%
>
> >>>                    /alterdatabasefolder=%folder.**dbalterfolder%
>
> >>>                    /runaftercreatedatabasefolder=**%folder.runaftercreate%
>
> >>>                    /drop
>
> >>> rem - recreate
>
> >>> "%DIR%Console\rh.exe"    /d=%database.name%
>
> >>>                    /f=%sql.files.directory%
>
> >>>                    /s=%server.database%
>
> >>>                    /vf=%version.file%
>
> >>>                    /vx=%version.xpath%
>
> >>>                    /r=%repository.path%
>
> >>>                    /env=%environment%
>
> >>>                    /createdatabasescript=%folder.**dbcreate%
>
> >>>                    /upfolder=%folder.upfolder%
>
> >>>                    /runfirstfolder=%folder.**runfirst%
>
> >>>                    /functionsfolder=%folder.**functions%
>
> >>>                    /viewsfolder=%folder.views%
>
> >>>                    /sprocfolder=%folder.sprocs%
>
> >>>                    /runAfterOtherAnyTimeScripts=%**folder.runafteranyother%
>
> >>>                    /permissionsfolder=%folder.**permissions%
>
> >>>                    /alterdatabasefolder=%folder.**dbalterfolder%
>
> >>>                    /runaftercreatedatabasefolder=**%folder.runaftercreate%
>
> >>>                    /simple
>
> >>>  --
> >>> You received this message because you are subscribed to the Google
> >>> Groups "chucknorris" group.
> >>> To view this discussion on the web visithttps://groups.google.com/d/**
> >>> msg/chucknorrisframework/-/**FUJoowjCfhoJ<https://groups.google.com/d/msg/chucknorrisframework/-/FUJoowjCfhoJ>
> >>> .
> >>> To post to this group, send email to chucknorri...@**googlegroups.com.
>
> >>> To unsubscribe from this group, send email to chucknorrisframework+**
> >>> unsub...@googlegroups.com.
> >>> For more options, visit this group at
>
> ...
>
> read more »

Tim Shepherd

unread,
Jan 2, 2013, 7:01:45 PM1/2/13
to chucknorris
Also, using the RefreshDatabase is not an option for me as far as I
can tell - my framework is not based on a model like NHibernate or
Entity.


On Jan 2, 5:14 pm, Rob Reynolds <ferventco...@gmail.com> wrote:
> You saw the answer hiding in here as well right? :D
> ____
> Rob
> "Be passionate in all you do"
>
> http://devlicio.us/blogs/rob_reynoldshttp://ferventcoder.comhttp://twitter.com/ferventcoder
>
>
>
> On Wed, Jan 2, 2013 at 4:13 PM, Tim Shepherd <tumblebu...@gmail.com> wrote:
> > oops - thought I'd changed all the sensitive stuff. That password is only
> > available on my PC here I've changed it nonetheless.
>
> > On Wed, Jan 2, 2013 at 10:54 PM, Rob Reynolds <ferventco...@gmail.com>wrote:
>
> >> Tim,
> >>  I believe you may want to change your password. This is a public group
> >> and has a searchable archive on the internet.
> >> ____
> >> Rob
> >> "Be passionate in all you do"
>
> >>http://devlicio.us/blogs/rob_reynolds
> >>http://ferventcoder.com
> >>http://twitter.com/ferventcoder
>
> >>>> SET folder.dbalterfolder=%sql.**files.directory%0002_**AlterDatabase\
>
> >>>> SET folder.dbalterfolder=0002_**AlterDatabase
>
> >>>> ____
> >>>> Rob
> >>>> "Be passionate in all you do"
>
> >>>>http://devlicio.us/blogs/rob_**reynolds<http://devlicio.us/blogs/rob_reynolds>
> >>>>http://ferventcoder.com
> >>>>http://twitter.com/**ferventcoder<http://twitter.com/ferventcoder>
>
> >>>> On Tue, Dec 18, 2012 at 7:25 AM, Tim Shepherd <tumbl...@gmail.com>wrote:
>
> >>>>>  Hi All
>
> >>>>> I'm trying to use Roundhouse 0.8.5 with the console. I've got a BAT
> >>>>> file that is launching rh.exe and doing a /drop first, the re-creates the
> >>>>> database using the /simple switch. What I can't see happening is the
> >>>>> scripts running in the "runaftercreatedatabasefolder"**. The database
> >>>>> dropping and creation run ok, and I can see it going through the other
> >>>>> script folders in the right order - is there something I'm missing (I've
> >>>>> based my bat on the samples from the zip I downloaded).
>
> >>>>> Here's my bat (I've condensed the rh.exe setting for space)
>
> >>>>> @echo off
> >>>>> SET DIR=%~d0%~p0%
>
> >>>>> SET database.name="DEV_**AcademyCore"
> >>>>> SET sql.files.directory=%DIR%.**.\
> >>>>> SET server.database="**MSSQLSERVER2008"
> >>>>> SET repository.path="https://**svn/DatabaseSchema <https://svn/DatabaseSchema>"
> >>>>> SET version.file="_BuildInfo.**xml"
> >>>>> SET version.xpath="//**buildInfo/version"
> >>>>> SET environment="LOCAL"
> >>>>> SET folder.dbcreate=%sql.**files.directory%0001_**CreateDatabase\custom_db_**cr­eate.sql
> >>>>> SET folder.dbalterfolder=%sql.**files.directory%0002_**AlterDatabase\
> >>>>> SET folder.runaftercreate=%**sql.files.directory%0003_**RunOnceAfterCreate\
> >>>>> SET folder.upfolder=%sql.**files.directory%0004_**RunOnceUpdates\
> >>>>> SET folder.runfirst=%sql.**files.directory%0005_**RunFirstAfterUpdate\
> >>>>> SET folder.functions=%sql.**files.directory%0006_**Functions\
> >>>>> SET folder.views=%sql.files.**directory%0007_Views\
> >>>>> SET folder.sprocs=%sql.files.**directory%0008_**StoredProcedures\
> >>>>> SET folder.runafteranyother=%**sql.files.directory%0009_**RunAnytime\
> >>>>> SET folder.permissions=%sql.**files.directory%0010_**PermissionRunEverytime\
>
> >>>>> rem - the drop
> >>>>> "%DIR%Console\rh.exe"    /d=%database.name%
>
> >>>>>                    /f=%sql.files.directory%
>
> >>>>>                    /s=%server.database%
>
> >>>>>                    /vf=%version.file%
>
> >>>>>                    /vx=%version.xpath%
>
> >>>>>                    /r=%repository.path%
>
> >>>>>                    /env=%environment%
>
> >>>>>                    /createdatabasescript=%folder.**dbcreate%
>
> >>>>>                    /upfolder=%folder.upfolder%
>
> >>>>>                    /runfirstfolder=%folder.**runfirst%
>
> >>>>>                    /functionsfolder=%folder.**functions%
>
> >>>>>                    /viewsfolder=%folder.views%
>
> >>>>>                    /sprocfolder=%folder.sprocs%
>
> >>>>>                    /runAfterOtherAnyTimeScripts=%**folder.runafteranyother%
>
> >>>>>                    /permissionsfolder=%folder.**permissions%
>
> >>>>>                    /alterdatabasefolder=%folder.**dbalterfolder%
>
> >>>>>                    /runaftercreatedatabasefolder=**%folder.runaftercreate%
>
> >>>>>                    /drop
>
> >>>>> rem - recreate
>
> >>>>> "%DIR%Console\rh.exe"    /d=%database.name%
>
> >>>>>                    /f=%sql.files.directory%
>
> >>>>>                    /s=%server.database%
>
> >>>>>                    /vf=%version.file%
>
> >>>>>                    /vx=%version.xpath%
>
> >>>>>                    /r=%repository.path%
>
> >>>>>                    /env=%environment%
>
> >>>>>                    /createdatabasescript=%folder.**dbcreate%
>
> >>>>>                    /upfolder=%folder.upfolder%
>
> >>>>>                    /runfirstfolder=%folder.**runfirst%
>
> >>>>>                    /functionsfolder=%folder.**functions%
>
> >>>>>                    /viewsfolder=%folder.views%
>
> >>>>>                    /sprocfolder=%folder.sprocs%
>
> >>>>>                    /runAfterOtherAnyTimeScripts=%**folder.runafteranyother%
>
> >>>>>                    /permissionsfolder=%folder.**permissions%
>
> >>>>>                    /alterdatabasefolder=%folder.**dbalterfolder%
>
> >>>>>                    /runaftercreatedatabasefolder=**%folder.runaftercreate%
>
> >>>>>                    /simple
>
> >>>>>  --
> >>>>> You received this message because you are subscribed to the Google
> >>>>> Groups "chucknorris" group.
> >>>>> To view this discussion on the web visithttps://groups.google.com/d/*
> >>>>> *msg/chucknorrisframework/-/**FUJoowjCfhoJ<https://groups.google.com/d/msg/chucknorrisframework/-/FUJoowjCfhoJ>
> >>>>> .
> >>>>>  To post to this group, send email to chucknorri...@**googlegroups.com
> >>>>> .
>
> >>>>> To unsubscribe from this group, send email to chucknorrisframework+**
> >>>>> unsub...@googlegroups.com.
> >>>>> For more options, visit this group athttp://groups.google.com/**
> >>>>> group/chucknorrisframework?hl=**en<http://groups.google.com/group/chucknorrisframework?hl=en>
> >>>>> .
>
> >>>>  --
> >>> You received this message because you are subscribed to the Google
> >>> Groups "chucknorris" group.
> >>> To
>
> ...
>
> read more »
Reply all
Reply to author
Forward
0 new messages