THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 8 (77 total posts) < 1 second(s)
  • re: Dacpac braindump - What is a dacpac?

    Jay, you can also make your changes to the other DB Project, build it, and use the generated dacpac to replace the existing one. It depends on how many databases you have in projects, of course. And yes, if you modify the referenced database in some fashion that will affect your projects, you'll need to re-extract. Ideally you've made that ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 21, 2014
  • re: Dacpac braindump - What is a dacpac?

    Been there before, been hit by the cross-DB stuff, learned to use the command line to at least get started and add DB references. Once those were set up, pulling in changes became a lot easier. Without that, the various dependencies almost always crashed the import/create project process. :) &nbsp; (And I learned a lot from Jamie over his many, ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
  • re: Dacpac braindump - What is a dacpac?

    @Jay, what problems are you having with extracting the DAC file? Have you tried using the SQLPackage command line to do that? I've had issues trying to use the GUI with some DBs that have cross-DB code or other things that don't necessarily translate as easily into a project.
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
  • re: Don’t be a dinosaur. Use Calendar Tree!

    Thanks for sharing. This sort of thing sounds like it could be really useful to keep track of events and keep everyone notified about them along with any changes.
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
  • re: Kill all the project files!

    Not sure about the way we'd handle some of the different file uses. I know some people build files based on certain things set within the project. I'm also not sure how we'd handle separating included post-deploy scripts from regular scripts based just on names/folders. The idea has some merit, but at the same time there are other things done by ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 14, 2014
  • re: Want a headless build server for SSDT without installing Visual Studio? You’re out of luck!

    Thanks for the update on this, Jamie. I'd tried doing a headless install and just gave up. I let the installer add the VS IDE in order to get everything working properly on our Jenkins boxes because it was a lot easier than trying to get the headless install working. It takes up extra space, but we have that much to spare and just don't use it ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 8, 2014
  • re: Responses to SSDT questions

    @Tyler, to me anything in the project could be considered an object - tables, stored procs, constraints, views, logins. If there's a script/file for it, I was treating it generically as an &quot;object&quot;. &nbsp;Set those to &quot;Not in Build&quot; and you'll still have the script that defined it, but won't try to work with it when you ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on July 25, 2014
  • re: Schema Compare or Publish [SSDT]

    Aaron, you may want to consider automating your script/diff generation. You can use SQLPackage to generate a diff report in XML and a change script as well. I've done that for several of our builds. We even have that set as an option in our automated build jobs to either just gen the report/change script or to also push the changes. (We haven't ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on December 19, 2013
  • re: Really useful Excel keyboard shortcuts

    CTRL+Shift+L turns on the filters for the current set. What I'd love to find is a good shortcut that uses the same date format as the one chosen when you set the Short Date. There is a shortcut for formatting dates, but it doesn't use that same date format. Sadly, it doesn't seem like one exists. It would be useful for when the datetime columns ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on December 6, 2013
  • re: Don’t learn SSDT, learn about your databases instead

    Stephen, What I'd likely start doing is clearing up the errors and warnings. Some warnings can be suppressed (perhaps an object in another database that you know exists or similar). The errors need to be addressed before you can build successfully. Double-clicking the error row should take you to the problematic file/line to address. ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on November 20, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement