Data Script not getting created

leosperry

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?

leosperry

I had to run as an admin 1 time. Now it works. I was getting some kind of error that asked to run as an admin.

My environment is Win 7 64bit