SQL Server, Command file for database projects

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> Command file for database projects

by markb » Sun, 12 Sep 2004 04:31:17 GMT

Is there a way to create a command file for database projects using
DTE? Basically I am using the BuildIt utility and I am trying to add a
step in the build process to create a command file in my database
project.

TIA
Buzz

Top

SQL Server >> Command file for database projects

by Narayana Vyas Kondreddi » Sun, 12 Sep 2004 17:13:51 GMT


I do this by calling OSQL.exe and providing the script files to it as input.
These OSQL calls are then palced inside a .Bat batch file and this batch
file will be called by the installing program (like Installshield).

See SQL Server Books Online, to familiarize yourself with all the parameters
of OSQL.EXE
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/








Top
Similar Threads

1. removing a project fomr the most recent project file - SQL Server

2. 2005 Setup Project: Installing SQL Server Express prerequisite with command line parameters 

Hi, I've got a setup project which installs SQL Server Express as a
prerequisite to my program.

The problem is that by default it's installed using the SQLEXPRESS
instance name and Windows Authentication login mode.

I'd like to have my own instance name and SQL Authentication, which is
easily achieved with command line parameters... is there a way to
specify that sort of thing?

Thanks

3. Authentication issues vb.net and DTS command line project - SQL Server DTS

4. build command for SSIS project 

Hi,

Does everyone know if there is command line to build a SSIS project 
equvilent to the build menu in the visual studio?

Thanks,

5. Build command for SSAS project

6. mySQL DB Database to HTML files (automatically create multiple static html files from a database) 

i need automatically create html files from a mysql db can be locally
on in the server. any idea?

thank for any help

7. USE Command With Dynamic Database Names Fails to Change Database - SQL Server

8. Using Access 2007 adp project files with SQL Server 2008 Express 

I am trying to work my way through Access 2007 Inside Out.  On page 133 the 
book instructs me to download and install SQL Server 2005 Express from 
www.microsoft.com/sql/editions/express/default.mspx and I could only find SQL 
Server 2008 Express.  I installed SQL Server 2008 Express and when I tried to 
open the project file Contact.adp that came with the book, I got the same 
error message that I got before I installed SQL Server 2008 
Express...something to the effect that it could not find SQL Server 2005 
Desktop Engine or Microsoft SQL Server (even though SQL Server 2008 Express 
was running).  There is nothing on www.microsoft.com/learning/support/books 
about this problem.

I did a search on "Access 2007 and SQL Server 2008 Express" in Microsoft 
Technical Communities and one of the threads in Discussion Groups led me to 
the SQL Server 2008 Migration Assistant for Access.  I successfully installed 
it, but it seems to only want to accept .accdb (or older) database files for 
conversion and NOT .adp project files.  

Is there any way to use SQL Server 2008 Express with Access 2007 .adp 
project files or do I need to find the 2005 version?  Thanks