No announcements
Found 1944446 threads
-
0 Votes
Export and Import DACPAC-Files (with schema and data)
You seem to be running into an issue with log/data file paths because the log and data file paths are contained in the dacpac.Answered | 2 Replies | 4197 Views | Created by Ferdl - Thursday, August 29, 2013 5:21 AM | Last reply by Ferdl - Thursday, September 5, 2013 7:07 AM -
1 Votes
dacpac deployment error to shard
Thanks, i applied to SQL 2014 instance on my local machine i choose Target Platform as "Microsoft Azure SQL Database" instead of "Microsoft Azure SQL Database ...Answered | 3 Replies | 1090 Views | Created by GKS001 - Sunday, November 5, 2017 7:41 PM | Last reply by Alberto Morillo - Monday, November 6, 2017 1:08 AM -
4 Votes
Reverse Engineer a MDS database as a .dacpac generates errors
Even from SQL 2012 SSMS I was getting an error about resolving references to MSDB during the DACPAC extract of the MasterData DB.Answered | 6 Replies | 7510 Views | Created by Todd C - Tuesday, January 22, 2013 2:19 PM | Last reply by Aleksandr Krymskiy - Thursday, May 23, 2013 3:19 PM -
0 Votes
Deployment of dacpac to elastic-pool db is ridiculously slow.
Hi Lorrin, When you deploy a dacpac using Dac, it compares the existing database with the dacpac.Answered | 3 Replies | 2191 Views | Created by Lorrin Ferdinand - Tuesday, March 14, 2017 5:42 PM | Last reply by Lorrin Ferdinand - Wednesday, March 29, 2017 8:15 PM -
0 Votes
File Type for dacpac files in Spanish?
Even after the next release we will not have it perfect unfortunately; the DACPAC file type will be in English for all language builds, even non-English installs.Answered | 5 Replies | 4021 Views | Created by Peter A. Schott - Wednesday, July 18, 2012 9:10 PM | Last reply by Sparks260 - Tuesday, May 3, 2016 6:29 PM -
0 Votes
Error publishing dacpac on server
We have installed the November release of the DacFx and its dependencies on several servers and been able to deploy dacpacs successfully.Answered | 1 Replies | 2998 Views | Created by Jeremy Hartley - MiX - Friday, December 7, 2012 10:30 AM | Last reply by Gert Drapers - Monday, December 10, 2012 12:56 AM -
4 Votes
Error Installing DACPAC Using sqlpackage.exe
Hey David, Can you let me know what version of DACFx you are using?Answered | 4 Replies | 21167 Views | Created by David Wagoner - Friday, October 12, 2012 3:33 PM | Last reply by David Wagoner - Friday, October 12, 2012 6:44 PM -
0 Votes
Using dacpac files in an integrated deployment process
Hey Dan, Although comparing dacpac<->dacpac is supported by the Script action, the best practice here is to compare the source dacpac you are ...Answered | 1 Replies | 2230 Views | Created by Dan Jørgensen - Monday, September 2, 2013 7:21 AM | Last reply by Adam Mahood [MSFT] - Wednesday, September 4, 2013 10:11 PM -
3 Votes
deploy dacpac via SSMS 2012 missing values
Sad enough, in 2016 the same problem with the DACPAC deployment wizard of SSMS 2012 still persists.Answered | 6 Replies | 7557 Views | Created by Jeremy Filburn - Tuesday, August 28, 2012 4:24 PM | Last reply by Markus Pöhler - Thursday, June 9, 2016 10:42 AM -
0 Votes
VS 2015 and using dacpac to resolve external reference
Apparently the fix is to create something called a .dacpac for SharedDB, a file extracted from the database in SSMS that contains a description of everything in SharedDB ...Answered | 2 Replies | 1570 Views | Created by JRStern - Wednesday, February 3, 2016 12:11 AM | Last reply by Zhanglong Wu - Wednesday, February 24, 2016 9:54 AM -
0 Votes
How to deploy dacpac to LocalDb with vNext build system?
Hi, The .dacpac has trigger?Answered | 8 Replies | 3375 Views | Created by K. Lewandowicz - Thursday, December 17, 2015 9:02 AM | Last reply by Shrek L - Tuesday, December 29, 2015 1:53 AM -
0 Votes
Publish DACPAC without publishing LOGINs.
There's no we we can stage each environment in our project, we don't even know what the logins are.Answered | 4 Replies | 6982 Views | Created by RobV8R - Wednesday, February 20, 2013 10:34 PM | Last reply by Dinesh Menon - Tuesday, April 16, 2013 2:47 PM -
0 Votes
Data conversion and DacPac
Thank you for your response and the detailed writeup of what is going on with this.Answered | 2 Replies | 2122 Views | Created by DeborahK - Saturday, April 27, 2013 2:49 PM | Last reply by DeborahK - Monday, April 29, 2013 2:52 PM -
0 Votes
'Origin.xml' is missing from the dacpac package - After upgrade SSDT to December 2012
Database Project created with SSDT VS2012 December Yes this is exactly what I'm doing.Answered | 12 Replies | 9194 Views | Created by Adam H 99 - Tuesday, March 5, 2013 4:32 AM | Last reply by Reuben H - Thursday, June 5, 2014 10:13 PM -
0 Votes
Can you compare a database to a DACPAC programmatically?
I would like the ability to essentially perform an automated schema-compare of a particular database to a particular DACPAC file.Answered | 1 Replies | 3570 Views | Created by Ryan _ FEI - Tuesday, June 11, 2013 8:46 PM | Last reply by Janet Yeilding - Tuesday, June 11, 2013 10:35 PM -
0 Votes
How to have an SSDT project create a dacpac file as part of build
I just can't figure out what is going to make the Schema Compare in SSDT happy, or how to ensure the file it wants is updated.Answered | 14 Replies | 13137 Views | Created by Mark Freeman - Wednesday, March 14, 2012 2:42 PM | Last reply by Adam Rink - Friday, June 8, 2012 9:08 PM -
0 Votes
Error on deploying dacpac through SSMS 2008 R2 SP1
DACPACs are supposed to make deployment easier not harder.Answered | 9 Replies | 5062 Views | Created by Erik van Dongen - Wednesday, March 14, 2012 7:52 AM | Last reply by steve-jansen - Thursday, April 19, 2012 4:24 PM -
0 Votes
Multiple SQL Files referenced by Post Deploy Script not included in Dacpac
You should be able to examine that file and verify the contents of the referenced scripts were successfully included in the generated dacpac.Answered | 1 Replies | 3982 Views | Created by closte - Monday, August 12, 2013 4:43 PM | Last reply by Kevin Cunnane [MSFT] - Monday, August 12, 2013 7:27 PM -
6 Votes
Error setting up DB reference from DACPAC.
There is an SSDT solution for that referenced DB, set to 2008 and it is deployed to a 2008 server elsewhere so I got the dacpac from that and it worked.Answered | 4 Replies | 15702 Views | Created by Mr.McGoo - Monday, November 5, 2012 10:38 PM | Last reply by z0rgath - Wednesday, March 29, 2017 10:30 PM -
0 Votes
Schema compare from-database-to-project does not consider dacpac
When the dacpac is modified and replaces the existing one - requiring a deletion of the old dacpac and addition of the new one - all the objects in the schema referenced in ...Answered | 2 Replies | 4169 Views | Created by Kazoo - Tuesday, June 5, 2012 7:38 PM | Last reply by Kazoo - Wednesday, June 13, 2012 12:56 AM
No announcements