Comments
Sort by recent activity
First, this works and I demo this regularly. The key is your agent. How have you configured your process?
For me, I use SQL Auth, and I set a user name and password as variables for the environment. I use a secret for the password. Alternatively, you could run your agent as an account that has access, but I tend to find this less secure, unless I were to set a different pipeline for this release, using a specific agent account that I can limit to sysadmins accessing for release. I would be wary of the same pipeline/agent for build and release. Two separate functions.
Here's my production release definition: [image]
For my production side, I have a variable here: [image]
The VSTS agent is functioning exactly as if it were logged in as you. You need to set security context and networking to be sure the agent can connect to your instance. After that, it's running DDL/DML, just as any other login/user. The rights/permissions depend on what you allow to happen. If a db needs to be created, then you need those rights. If it's just CREATE/ALTER/DROP objects, those rights are needed. / comments
First, this works and I demo this regularly. The key is your agent. How have you configured your process?
For me, I use SQL Auth, and I set a user name and password as variables for the environment...
That's strange. Yep, seems like a bug. Reporting to the dev team [image] / comments
That's strange. Yep, seems like a bug. Reporting to the dev team
What version of SQL Prompt? Seems to work in v8 [image] / comments
What version of SQL Prompt? Seems to work in v8
Well, Prompt get remove if you reformat (CTRL+K,Y). As for removing on scripting, that's an SSMS function. We can't jump into that. Now, the Prompt menu with script as alter might be able to tag this together with a format, but I'm not sure. I think this is just calling the SSMS function.
Is there a reason reformatting doesn't work? / comments
Well, Prompt get remove if you reformat (CTRL+K,Y). As for removing on scripting, that's an SSMS function. We can't jump into that. Now, the Prompt menu with script as alter might be able to tag th...
This isn't SQL Prompt, at least, not necessarily. If you right click a procedure and choose script, you get SSMS defaults. If I do that, I get this: [image]
If I then reformat with SQL Prompt (CTRL+K, y), I get this: [image]
I have my formatting set to not use extra brackets [image] / comments
This isn't SQL Prompt, at least, not necessarily. If you right click a procedure and choose script, you get SSMS defaults. If I do that, I get this:
If I then reformat with SQL Prompt (CTRL+K, y), ...
Can you provide a bit more detail here? Are you trying to ignore specific tables, as in some random names? Are you looking to ignore those with a pattern?
One thing to look at is a SQL Compare filters: https://documentation.red-gate.com/display/SCO4/Viewing+the+comparison+results#Viewingthecomparisonresults-Usingthefilter
You can build a file and then use that as a command line switch: https://documentation.red-gate.com/display/SCO4/Command+line+switches#Commandlineswitches-/filter:<filterfile.scpf> / comments
Can you provide a bit more detail here? Are you trying to ignore specific tables, as in some random names? Are you looking to ignore those with a pattern?
One thing to look at is a SQL Compare filt...
We don't have the column picker in the UPDATE, which is a hole. I've noted this to the product team.
However, the pattern of adding the column name in there is interesting. I don't have a Prompt solution for you right now. Certainly, you could use Shift+ALT to help here. Here's what I'd do: https://youtu.be/XdIA0EFrXOU
Let me know if this helps. I've logged this with the team for discussion. / comments
We don't have the column picker in the UPDATE, which is a hole. I've noted this to the product team.
However, the pattern of adding the column name in there is interesting. I don't have a Prompt so...
I've passed along the request. The list is:
CSV - Use values in a CSV as random values
File Import - Import files into a column, useful for images or BLOB values
File List - Import values from a text file.
Python script - Generate data using a Python script
Regexp - Generate values with a regular expression
Simple expression - One line expression that selects from another table, a Python function or a C# DateTime method
SQL Statement - Use a SELECT statement to return data
SQL FK - Use a column in another table as a FK
SQL defaults - use the default for a column
Text Shuffler - random shuffle of text you enter
Weighted List - list of values weighted by a ratio / comments
I've passed along the request. The list is:
CSV - Use values in a CSV as random values
File Import - Import files into a column, useful for images or BLOB values
File List - Import values from a te...
I tried a few things. One that does work, if you have the domain mapping, is to use this python function: def main(config):
penlist = ['A', 'B', 'C']
pencillist = ['D', 'E']
if Device == 'pen' or Device == 'Pen':
return random.choice(penlist)
else:
return random.choice(pencillist)
I'm assuming here your colunm is Device, and this is the appropriate mapping. I did need to add a reference to my list of Python 2.7 libraries to get the random module. / comments
I tried a few things. One that does work, if you have the domain mapping, is to use this python function:def main(config):
penlist = ['A', 'B', 'C']
pencillist = ['D', 'E']
if Devi...
What you really have here is a key of sorts. Does the database have any referential integrity for these columns? Or do you have a source database that has this type of constraint? / comments
What you really have here is a key of sorts. Does the database have any referential integrity for these columns? Or do you have a source database that has this type of constraint?