HighTechTalks DotNet Forums  

MSBuild for running .sql on 2005 and 2000

Dotnet Scripting microsoft.public.dotnet.scripting


Discuss MSBuild for running .sql on 2005 and 2000 in the Dotnet Scripting forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
slh
 
Posts: n/a

Default MSBuild for running .sql on 2005 and 2000 - 09-14-2006 , 05:06 PM






I'd like to have the same MSBuild script run .sql scripts for me on a machine
with SQL Server 2000 or a different machine with SQL Server 2005. I have the
ISQL and SQLCMD statements working for both environments. Can anyone
recommend a target Condition I can use to distinguish between these two
environments? The script will be shared on several machines so I can't
depend on machine name or SQL installation path.

Thanks in advance for your help!

Reply With Quote
  #2  
Old   
Rashad Rivera
 
Posts: n/a

Default Re: MSBuild for running .sql on 2005 and 2000 - 09-22-2006 , 11:33 PM






I would recommend using a registy condition insead of a target condition.
You could easily find out what version of SQL is installed and the computer
name via this method.

- Peace be with you in the name of Him who died on the cross; Jesus Christ

Rashad Rivera

"slh" <slh (AT) discussions (DOT) microsoft.com> wrote

Quote:
I'd like to have the same MSBuild script run .sql scripts for me on a
machine
with SQL Server 2000 or a different machine with SQL Server 2005. I have
the
ISQL and SQLCMD statements working for both environments. Can anyone
recommend a target Condition I can use to distinguish between these two
environments? The script will be shared on several machines so I can't
depend on machine name or SQL installation path.

Thanks in advance for your help!



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.