Hmmm...that <replace> looks like a good idea. Thanks... -----Original Message----- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 3:06 PM To: Ant Users List Subject: RE: sql task sp_dboptions problem
wellllllllllllllll... (more than one way to skin a cat) if the cleanDB.sql file has db-specific references, you could "specialize" this file before running it using the <replace> task. that would work if we're talking about changing names... it could be made to work if we're talking about selectively executing only some parts of the file, but it would get messy quite quick! /t >-----Original Message----- >From: Rizwan Merchant [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 9:00 PM >To: 'Ant Users List' >Subject: RE: sql task sp_dboptions problem > > >I don't think so, because the cleanDB.sql file still refers to >a specific >database. What I want to do is somehow pass a parameter to the >cleanDB.sql >file so that the file can be generic. > >-----Original Message----- >From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 25, 2005 2:51 PM >To: Ant Users List >Subject: RE: sql task sp_dboptions problem > >wouldn't this work? > > ><sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" > >url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab >aseName=$ >{the.database.i.wanted.to.pass}" > userid="sa" > password="${the.password.of.the.database.i.wanted.to.pass}" > src="cleanDB.sql" > /> > >>-----Original Message----- >>From: Moran Ben-David [mailto:[EMAIL PROTECTED] >>Sent: Thursday, August 25, 2005 8:43 PM >>To: 'Ant Users List' >>Subject: RE: sql task sp_dboptions problem >> >>Sorry Razwan, >> >>I am not familiar with the <sql> task enough to help you on >>that. However, >>one thing I can suggest is that instead of using the tasks' >>"src" attribute, >>you put the sql from cleanDB.sql in you're ant file as such: >> >> >><sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" >>url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab >>aseName=on_de >>velop" userid="sa" password="on_develop"> >> >> -- example code from cleanDB.sql >> DROP DATABASE ${the.database.i.wanted.to.pass}; >> >></sql> >> >>Moran > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
