THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 8 (80 total posts) < 1 second(s)
  • re: An appeal for SSDT developers – Red Gate want to hear from you

    More than willing to chat with them. I know I've discussed some SQL Source Control / SSDT stuff with them in the past, though. They can shoot me a message on twitter - @paschott.
    Posted to Jamie Thomson (Weblog) by Peter Schott on November 13, 2014
  • re: Table designer (10 days of SSDT – Day 4)

    @Jag - that could be a holdover from the old VS DB Project format where everything was broken out into separate scripts. If you want to do something similar, you can right-click in the project to add a new constraint as a separate file. To me, it's easier to manage as part of the table definition, but I can see some might prefer splitting each ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on October 1, 2014
  • re: Day 1 – Online and offline (10 days of SSDT)

    I haven't played with the &quot;online&quot; portion of Object Explorer too much. I may have to look at that a little more closely. Most of my work has been in the offline world, making sure the project builds successfully, getting post-deploy scripts ready, etc. Sounds like I might want to use the online mode a little more if it just previews ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on September 17, 2014
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement