We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

Search found 5 matches

Go to advanced search

by Hotzi
Tue Nov 04, 2014 9:00 am
Forum: Common Problems
Topic: Installing/updating a MSSQL server database with a dacpac
Replies: 7
Views: 13937
 
Jump to post

Re: Installing/updating a MSSQL server database with a dacpa

Hi Daniel,

thanks for your answer.

Ok, i have added the SQL-Script in the SQL Scripts page:
SQL Script.jpg

under the File Section i have add the DACPAC file, which i would deploy with the SQLPackage.exe:
DACPAC to Publish.jpg

and under the Custom Actions I have add to execute the SQLPackage ...
by Hotzi
Tue Oct 28, 2014 10:59 am
Forum: Common Problems
Topic: Installing/updating a MSSQL server database with a dacpac
Replies: 7
Views: 13937
 
Jump to post

Re: Installing/updating a MSSQL server database with a dacpa

Hi,

i also want to install a DACPAC file via SQLPackage.exe
After Installation the database i want to execute a SQL-Script.

For this you can simply add your .dacpac file under the desired directory path from "Files and Folders" page. Also, if you need to call a specific tool (e.g. SqlPackage.exe ...
by Hotzi
Thu Oct 02, 2014 1:08 pm
Forum: Common Problems
Topic: Prerequisites installation: Check return value
Replies: 1
Views: 2783
 
Jump to post

Prerequisites installation: Check return value

Hello,

i start on Prerequisites an installation (Execute a command-line tool)
The return value i saved in the unforeseen property-field.

So now i would break my (main) installation when the return value (of the command line tool) isn't correct.
The checkbox "Continue with main installation even if ...
by Hotzi
Thu Oct 02, 2014 9:03 am
Forum: Common Problems
Topic: Problem with SQLPackage.exe
Replies: 3
Views: 6185
 
Jump to post

Re: Problem with SQLPackage.exe

Thanks for the quick response.
Yes, i think Prerquistes are the right way.

Requirement for the SQLPackage-Execution is SQLServer 2012 Express

So that the SqlPackage works correct i have to add also 4 additional files (placed in C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\), 1 ...
by Hotzi
Thu Oct 02, 2014 6:36 am
Forum: Common Problems
Topic: Problem with SQLPackage.exe
Replies: 3
Views: 6185
 
Jump to post

Problem with SQLPackage.exe

Hello,

i want to update my datatabase (dacpac file) with the SQLPackage-Utility from Microsoft.
In this case i have created a Custom Action - "Launch attached file":
SourcePath: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin
Command: /Action:Publish "/SourceFile:C:\Temp\Test.dacpac ...

Go to advanced search