Settings and activity
14 results found
-
18 votes
Jim
supported this idea
·
-
29 votes
An error occurred while saving the comment Jim
supported this idea
·
-
34 votes
It would be great if you could let us know more about how you’d use a Prompt API / command line version of Prompt.
What problems are you having without it?
How are you getting around those?
How would this make your work better?Jim
supported this idea
·
-
84 votesJim
supported this idea
·
-
4 votesJim
supported this idea
·
-
16 votesJim
supported this idea
·
An error occurred while saving the comment Jim
commented
Would like to see this in the command line. Currently only supports SVN etc. using the /Revision switch.
Specifying a revision other than HEAD is only supported with TFS, SVN and Vault. If you're using another source control system, we recommend checking the revision out to a local folder and using the /Scripts1 switch.
-
77 votesJim
supported this idea
·
-
76 votesJim
supported this idea
·
-
131 votes
An error occurred while saving the comment Jim
commented
This seems like it is very possible since just about every editor out there paid and free provides some option like this.
As others have said, onboarding an existing database with decades old sql script with really bad formatting makes the job so much more difficult. Especially with code history. Linking a database and being able to format the scripts (stored procedures) would turn this into a non-event.
The work around is to create the scripts, format them and then commit to source control. This is klunky and relies on manual adherence.
Jim
supported this idea
·
-
131 votesJim
supported this idea
·
-
137 votes
An error occurred while saving the comment Jim
commented
Not integrated but this article shows you how to kind of do it:
Jim
supported this idea
·
-
156 votes
An error occurred while saving the comment Jim
commented
Wow... 11 years. Not getting my hopes up...
-
476 votes
Thank you everyone for the suggestions and votes for this over the years.
I’d like to surface up a workaround for the “linking” problem which is mentioned in the comments. For the use case of easing pains around environment setup with a large number of databases, we have had customers find success using code based off Alessandro Alpi’s blog post: https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/
I do understand that this is a broader issue and hear that many of you also want command line or API support for the product in general.
If there are specific scenarios or workflows that would be useful to automate for you, this feedback is also very useful, and if you have details on the type of VCS you use and the workflow (such as a branching model) that it would fit in to, that would be very helpful for us to hear as well.
An error occurred while saving the comment Jim
commented
Hi Kendra,
I went and looked at Alessandro's blog post. While it "works", it is readily apparent that PowerShell is not his best skillset. I have forked his github repository and will clean it up into something more serviceable. Features like this would really be better served by providing cmdlets very similar to the SQL Change Automation product that will provide the functions customers would need to automate the most used operations in their CICD processes.
Link an existing database
Get Latest
Get Latest by tagMarketing your product as the pathway to CICD and then leaving these gaps in your implementation is unexpected.
Jim
An error occurred while saving the comment Jim
commented
Hi David,
I can only speak for myself, but as our environments become more fluid and virtual, the manual linking of the database would be replaced with optimally a PoSH command with parameters to perform the link action and get latest from a branch which is passed in as a parameter. We have 10 or so developers and each developer manually linking a dozen or so databases can get expensive as compared to when we can take a configuration management approach and automate the whole process freeing up the lost developer time.Jim
supported this idea
·
-
9 votesJim
supported this idea
·
I see this as a big thing, surprised there are not more votes. Refering to Tim Berneman, this can be the difference between doing something potentially damaging unintentionally and not. We have our tabs colored red for production so it is very clear, however it would be nice to have the same coloring applied to the background of the servers in the explorer pane so there is no doubt what environment I am working in when performing development and maintenance.