Options

Data Script not getting created

leosperryleosperry Posts: 3
edited March 17, 2011 6:08PM in SQL Packager Previous Versions
I am trying to create a script for our build process that will create a new db from scratch so that I can include it with our installer.

I'm Calling the Sql Packager like this
SQLPackager.exe /argfile:c:\temp\PackageSettings.xml

Here is the contents of PackageSettings.xml:
<?xml version="1.0"?> 
<commandline>
	<force/>
	<verbose/>
	<out>c:\temp\output.txt</out>
	
	<makescript/>
	<scriptdestination>c:\temp</scriptdestination>
	
	<server1>localhost</server1>
	<database1>MyDb</database1> 	
		
	<schemascript>c:\temp\CreateDB.sql</schemascript>
	<datascript>c:\temp\DefaultData.sql</datascript> 
	
	<includeschema>Table</includeschema>
	<includeschema>StoredProcedure</includeschema>
	<includeschema>View</includeschema>
	
	<includedata>Table</includedata>

</commandline>

With the above set up, I only get CreateDB.sql. It never creates DefaultData.sql.

How do I get it to make the data script?

If I could get it to make a single script like the GUI does that would be even better.

I have not seen the scriptdestination tag make any difference. What does it affect? Why is it required if it doesn't change anything?

Comments

Sign In or Register to comment.