Questions tagged [scripting]
For questions about generating or using language scripts, for example scripting a database object definition.
326
questions
-2
votes
1answer
28 views
Iterate through a list of strings In SQL scriipt
I'm trying to create a sql file that iterates through a list and get me the information from a group of servers and save it on CSV file. The DB is Oracle, just in case :S.
I'm running the file using ...
0
votes
1answer
39 views
Take a “slice” of a SQL Server database: for all tables, get only the rows that join (directly or indirectly) to a specific row
For audit purposes, I'm trying to obtain a copy/export of a DB but including only the rows from each table that have relevance to a small collection of rows in some table. So every row of every table ...
0
votes
0answers
51 views
The SQL Scripter library is running a SELECT COUNT(*), how do I stop it?
I'm using the Microsoft.SqlServer.Management.Smo.Scripter library from within a PowerShell script to pull SQL object creation scripts from a DB as part of an automated process. The user account used ...
1
vote
1answer
37 views
How to script server level objects in sql server?
I regularly do sql server installations (mainly sql server 2016), in virtual machines or otherwise, and I have a bunch of things like permissions, and linked servers and endpoints that I have mostly ...
0
votes
0answers
13 views
Shell Script to kill slow running Mongo Queries
I need to create a shell script that finds and kills long running mongo queries more than a specified threshold e.g. 15sec I plan to use db.currentOp(); and db.killOp(); to find and kill queries but I ...
1
vote
0answers
26 views
How to simulate slow queries on MongoDB
I need to write a shell script that finds and kills long running mongodb queries, but I don't have access to the database that runs slow queries, how to I simulate running slow queries on my local ...
0
votes
0answers
10 views
Appropriate language to write a Script that Kills Long running query MongoDB
I want to create a script that kills queries when they reach specific time threshold, I will be using db.currentOp() method to get information about currently running queries, and use db.killOp to ...
0
votes
0answers
19 views
using regular expression in bigquery
I have a table in bigquery with some formulas and would like to replace few things from it.
SELECT FORMULA,element.name,FUNCTIONS.fun_temporal FROM `test-project.FORMULAS.FORMULA_HISTORY`
,unnest(...
0
votes
0answers
19 views
cloning foreign keys after prod-dev wipe
I am currently using mariadb, and I am working with quite a bit of data. we are creating nightly wiped clones of our production database, so our devs have a fresh copy without any customer data.
I am ...
0
votes
0answers
27 views
I need a script to cycle all tables in postgres to analyze if needed
I need a script to cycle all tables in postgres to analyze if needed.
Something like:
create or replace PROCEDURE analyze_all_tables ()
language plpgsql
as $$
declare
q TEXT;
r RECORD;...
1
vote
3answers
157 views
DB2, How to save all stored procedures as files
How does one extract all stored procedures from a DB2 schema as individual files (without using Data Studio so it can be scripted). I need them all so I can uploaded to source control. I have found ...
1
vote
0answers
39 views
Keeping the same order of selected records while inserting to another table
I am running a below query in big query
insert into `test-project.temp_test_dataset.cluster_records`
(pm,col1,col2,col3,total)
select pm,col1,col2,col3,total from (
select 'ingest' as pm,col1,col2,...
2
votes
1answer
41 views
Where can I find SQL Developer Database examples (scripts) to add data to practice?
Where can I find SQL Developer Database examples (scripts) to add data to practice?
I require SQL scripts that will add tables and data on those tables in order to practice with Power Bi.
0
votes
2answers
256 views
Postgresql Backup all databases seperate files
I need to create an automatic backup of all databases from PostgreSQL ( running on a Windows machine ).
I need to know if is possible to get backup of all databases but on separate files?
Using ...
0
votes
1answer
74 views
SQL Server Command Line Install - How to change the edition?
I am creating a script to install SQL Server via the command line.
I cannot see a way to choose the edition I want to install. The GUI on my install media offers Evaluation, Developer or Express:
(...
0
votes
1answer
52 views
How to save Outlook attachment in a drive with a new name and overwrite if it already exists? [closed]
I am using below VBA script to download attachments from email and save it to my windows directory.
I need help to modify this script - 1) to save rename the attachment before saving it 2) Overwrite ...
0
votes
1answer
155 views
Oracle - Delete dmp files from ASM diskgroup
I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it.
ASMCMD> ls
exp1.dmp
exp2.dmp
exp3.dmp
exp4.dmp
ASMCMD> pwd
+DATA/EXP
How ...
1
vote
4answers
604 views
Error “the system cannot find the file specified” when opening a large SQL Server file
I have generated the script of my whole SQL Server database into a file and it's more than 36 GB. When I try to open it, I get the following error:
The system cannot find the file specified.
At ...
0
votes
0answers
13 views
How to shutdown and startup a database to delete datafiles in between
OS: Windows 10 Professional / DBMS: Oracle 18c XE
How would one approach the issue of losing a connection while shutting down the database?
I would like to have one script which deletes datafilepaths ...
0
votes
0answers
43 views
SQL Failover and Failback Script for SRM Recovery Plan(preferably power shell or CMD or Batch script)
OS: Windows Server 2016 Standard
SQL: SQL Server 2016 Enterprise
SQL Setup: Two Nodes(Primary and Secondary Node) in PDC(Primary Data Center) having Always On Availability Group with Synchronous Mode ...
1
vote
1answer
46 views
Generate SQL scripts in powershell
I want to be able to generate simple repetitive scripts in SQL using Powershell as the scripting language.
For example, If I want to generate a SQL GRANT command for every table in a database, and ...
0
votes
1answer
40 views
How to quote a SQL*Plus identifier in a bash script?
I get "ORA-00904: "MEMORY_TARGET": invalid identifier" no matter how I try to quote the identifier in the following command:
MEMORY_TARGET=$(su - orat01 -c " echo 'select ...
0
votes
1answer
272 views
generated column in mySQL workbench
I am a beginner and start designing small database. I've found that to automatically generate value from the table, I can either use a trigger or compute them when forward engineering.
Therefore, I've ...
4
votes
2answers
6k views
What does “psql: /usr/pgsql-11/lib/libpq.so.5: no version information available (required by psql)” actually mean?
I have a question regarding following output:
[nikola@192 ~] $ sudo su - postgres
[postgres@192 ~] $ psql dvdrental postgres
psql: /usr/pgsql-11/lib/libpq.so.5: no version information available (...
2
votes
1answer
29 views
How to change user running audits mssql
I've been tasked with setting up our SQL server audits - despite having never done this before. So please forgive a really basic question.
I setup a specific user, sqlAudits, that I would like to own ...
0
votes
1answer
22 views
PostgreSQL - How to list all foreign key link to Primary key of a table
I have a table res_users with primary key id
I would like to list all the foreign key link to id from all the tables in my database.
0
votes
1answer
464 views
output psql results and errors to a file
I want to display the results of psql queries on a file.In the log just the name DO for the anonymous Bloc is being displayed.
The following is being executed from a shell script file :
psql --host=...
0
votes
1answer
339 views
Shell script - psql run multiple statements from a variable one by one in one transaction
Im preparing a shell script to generate analyze command and all the commands will go to a variable.
echo $analyze_query
analyze tbl1;
analyze tbl2;
analyze tbl3;
Now I want to run one by one, and ...
1
vote
1answer
59 views
how to script out proxy accounts?
I have servers where I use proxy accounts to run ETL processes or even to backup SSAS databases using powershell through a job.
I can see what AD Accounts are related to my proxies:
use msdb
go
...
0
votes
1answer
81 views
v$ tables not recognized in a sql statement of a shell script
I have .sh script with this block:
sqlplus -S / as sysdba <<EOFILE
set feedback off
set lines 2000
set pages 20000
col db_size for a15
alter session set nls_date_format = 'DD-MM-YYYY HH24:MI:...
0
votes
1answer
46 views
script to find all bigint that can be converted to int fields in postgresql performance
I want to compact a postgresql 11 db and my idea is to convert lots of bigint to int data types if and only if there is a reasonable lag to the limit of int data type considering the data inside.
So, ...
-2
votes
1answer
140 views
How to resolve error “SQL0104N” when running “db2 prune logfile prior to” command?
I wrote an script to delete transaction log files in db2. I need to delete all the files prior to the active log file.I wrote this code as .sh file
db2 connect to DWHDB
db2 get db cfg | grep '/...
0
votes
0answers
56 views
Loading 260GB worth of CSV into MySQL in Linux
I'm bulk loading a few thousand CSVs totaling ~260GB and ~4.5 billion rows to MySQL using mysqlimport calls on each CSV executed within a bash script. The MySQL installation and the data itself are ...
1
vote
2answers
714 views
How to pass Oracle Wallet auth to sh script?
I am running an Oracle DB update script that requires password. I have Oracle wallet installed. How to pass Oracle wallet to sh script so that I don't have to enter password when running the script?
...
4
votes
1answer
102 views
how to remove all permissions in a database?
every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
0
votes
1answer
287 views
MySQL ERROR 1064 (42000) insert via bash script (RHEL)
MySQL Server: 8.0.16 Commercial
OS: RHEL 7.5
I have written a simple script, to insert certain information into a database table.
Following is my script
# cat ~mysqldba/bin/connections.sh
#!/...
0
votes
4answers
2k views
oracle oraenv script bash
I want to do same commande shell CLi into a script
Command shell without script (CLI)
su - oracle
export ORAENV_ASK=NO
export ORACLE_SID=HRPRD
. oraenv
env | grep ora
output:
USER=oracle
**...
3
votes
0answers
1k views
Generate scripts wizard hangs when loading database information [closed]
I am trying to script out a database from an instance of SQL Server 2017, so I can load it into an instance of SQL Server 2014. I right-clicked on the database, chose Tasks -> Generate Scripts, and ...
-1
votes
1answer
241 views
Syntax Error in Create Table Statement
I'm using Oracle 12c, I want to create a table with partition by year and subpartition by month like this.
create table par.Log_his
(
ID NUMBER(20) not null,
Year number(4,0), -- ...
0
votes
1answer
829 views
Script to install Oracle client 12c2 on Redhat linux 7.5
Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
0
votes
3answers
97 views
How do you generate a build script for all views [duplicate]
I would like to create a build script that can run through and recreate all views (and stored procedures too, but one step at a time).
I am trying to create a baseline of all of our user databases (...
2
votes
2answers
991 views
how to add data compression to a primary key of a table?
We work with tables with over 300GB of size, a small percentage of them tables use sparse columns
although that doesn't always agree with CPU utilization as this question shows.
For the tables that ...
1
vote
2answers
84 views
Find jobs that succeeded, but had steps that failed
Is it possible to find jobs that succeeded, but that had steps that failed like the desired output shows? I'm new to this side of development and I'm not sure about all of the system tables, etc. If ...
3
votes
2answers
604 views
Suppress database change message in SQLCMD.exe
I am writing a script generation script.
The script is generating list of DDL statments.
The util_generator.sql generation starts with database connection:
USE [TARGET_DATABASE]
GO
...
Many queries
...
2
votes
1answer
372 views
How to insert multiple IP addresses in a pg_hba.conf file via unix shell script?
I need to write some IP addresses to the pg_hba.conf file of my Postgresql, in order to allow remote access from those IP to my machine.
I have the following code in shell script to do that for a ...
0
votes
2answers
24 views
Fetching wrong results on comparing a variable with 0 in unix
I have the following code in unix
#!/bin/bash
user=$1
username=$user'%'
DB_name=$2
userpwd=$4
export PGPASSWORD=$3
psql -h localhost -U postgres -d $DB_name -At -c "SELECT COUNT(*) AS ...
1
vote
1answer
48 views
Access .sql script files on other partition or hdd [closed]
I'm running a Linux Mint 19.1 - Tessa OS, which for you who might not know it is based on Ubuntu 18.04 - Bionic Beaver. On this I have installed postgresql 11 which work well. There is one problem ...
1
vote
1answer
272 views
How to find out if an index is aligned
I'm struggling to find any confirmation within sql server or sql management studio that my index is in fact aligned with my partition.
I'm creating a primary key constraint on a partitioned table:
...
1
vote
1answer
63 views
How to create a job that uses Powershell script? [duplicate]
I have a powershell script which deletes old backups from NAS storage. I have already tested it using Windows Powershell and it works but I couldn't perform the same thing in SQL Server. I have ...
-3
votes
2answers
455 views
Need a shell script that can run a oracle query and produce output in .csv format
Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
