Questions tagged [automation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?

I currently run PostgreSQL 12.4 on Windows 10. Since the "BigSQL" distribution is no longer around, the only choice is to use the EnterpriseDB installer for the initial installation: https://...
1
vote
1answer
60 views

MySQL dump to MariaDB issue with collation

I have a django app running on a staging server (windows server 2012) with a MariaDB database. I have a git hook running mysqldump locally when I push to the staging branch. On the server I have a ...
0
votes
1answer
32 views

what databases are already set up in the log-shipping, and which ones are not?

I am setting up log-shipping from server1 to server2. there are many databases on server1 and I want to automate the process. I have already done a few databases manually, while I am working on the ...
0
votes
1answer
26 views

Looking for a tool for managing complex powershell automation processes with multiple scripts [closed]

Sysadmin here, I'm wondering what tools you all use to manage large scale automation tasks with powershell. I currently have several powershell scripts that are regularly used, but do not interact or ...
0
votes
1answer
21 views

Does mongo *really* need a dedicated volume, if I need to back it up?

TLDR; What's the easiest way to automate a mongodb backup of a 20-gig DB? We run mongo on the same KVM (VPS) as the web app; the server runs Debian. We/I don't need/want to backup the entire fs on a ...
0
votes
0answers
22 views

What's the easiest way to automate Mongodb backups, for offline storage? [duplicate]

So, I'm almost finished building my first major production web app, and am wondering how to manage backups. Weekly cold snapshot backups via my vps online admin seem ideal - but weekly downtime sounds ...
0
votes
2answers
35 views

How do I find out whenever a value changes in a certain column?

Need help if anyone can offer! I currently have my select statement returning the TOP 1000 * results from a table. They are CC numbers that are currently active. I'd like to see how I can go about ...
0
votes
0answers
6 views

Execute special processing on calling table in hive

I want to set up so that when someone calls my table, it first does some processing to the table, and then later, restores the table when it is no longer being used. Is there a way to do this? I think ...
1
vote
1answer
71 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 ...
1
vote
1answer
35 views

Is it possible to run a stored procedure automatically on a new database when it is attached?

Replication is causing issues on our daily snapshots. What we would like to do is remove replication automatically on a database when it is attached to the SQL server. Is this possible?
0
votes
0answers
27 views

Automated flow of creating user in Azure AD to MySQL that runs in K8s cluster in Azure

My ASP.net core application runs on Azure K8s cluster, the app uses authentication that is configured in Azure (the app is registered in Azure AD and some accounts are created there to use it). The ...
0
votes
0answers
37 views

Auto running SQL script with Azure database server

I am trying to automate a report that is generated from the database on Azure database server. I am using below script in the batch file but I get the error. Script: osql -U firstname.lastname@company....
0
votes
1answer
51 views

Auto running SQL script

I am using the below command in my batch file and running it via task scheduler. osql -S myserver\sqlexpress -E -i "c:\test.sql" -o "c:\output.txt" I get the error stating that: ...
1
vote
0answers
35 views

Oracle Scheduler Job - Exporting of CSV File every 16:01

I have already executed the code for scheduler. However, I have a problem whenever I execute my scheduler. Can someone help me with this? I'll appreciate all your response. My procedure code: create ...
0
votes
3answers
827 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 ...
1
vote
1answer
69 views

SQL Server Configuration File and InstanceName parameter

We have a configuration file at E:\SQL_Server_2016_Install\MyConfigFile.ini that looks like below: [OPTIONS] ACTION = "Install" FEATURES = SQLENGINE INSTANCENAME = MSSQLSERVER AGTSVCACCOUNT =...
0
votes
1answer
30 views

is there a DDL generator out there where you can start with CSV/TSV to create DDL for Cassandra

Is there a DDL generator out there where you can start with CSV/TSV (or maybe even JSON) to create DDL for Cassandra?
0
votes
1answer
26 views

Is there a way to optimize the process of uninstalling and installing SSMS?

in terms of patching sql server 2016 to the latest cumulative patches, I found out that stopping the services helps avoiding lots of inconveniences, specially if there is log shipping and replication ...
1
vote
1answer
407 views

Unable to replicate schema changes in transactional replication

I have implemented a transactional replication on one of my dbs. In the documents provided by Microsoftsql (here and here), I should be able to change the schema and that these changes will be ...
1
vote
2answers
378 views

How can I script administrator permissions on a SSAS server?

I am an administrator for a bunch of SSAS Instances. Sometimes I need to install or migrate SSAS instances to different machines or even different AD domains (we have a couple of different AD domains ...
9
votes
3answers
7k views

How can I install the SQL Server PowerShell module on an offline machine?

I have some SQL Server machines that cannot connect to any external sites. I have been using PowerShell more and more when managing databases, so I definitely need this module to be installed so ...
2
votes
1answer
283 views

Trying to use SSRS rsconfig.exe in silent mode to create the ReportServer and ReportServerTemp databases on a local instance

I have installed a brand new SQL 2017 Enterprise instance on a Windows 2019 Datacentre VM. I have then installed SQL Server Reporting Services via the command line (/quiet, /norestart, etc) and all ...
3
votes
2answers
8k views

how to list all features installed in a sql server instance?

There are other Installation related questions with similar details here and here. I could not find anything related to listing the installed features in sql server 2016 though. I can do it manually ...
0
votes
1answer
34 views

Automating database restoration of SQL Server transaction log files on standby mode

I am wondering if I get help from this house on the following issue. I have a standby database that should be restored with the set of transaction log files I get from the vendor's(eClincalWorks) ...
1
vote
1answer
180 views

Mongodb automatic Replica Set creation with JS driver

The MongoDB docs state that one can use the mongo client console to initialize replica sets by running rs.initiate([config]). However, I don't want to have to manually use the command line for this. ...
0
votes
1answer
400 views

Automating SQL scripts in Toad for Oracle (13.1)

I'm not a DBA, so bear with me. I've scheduled tasks through Toad's automation designer, but this uses Windows task scheduler. It's using Oracle 12c. All I'm doing is updating (creating/dropping) ...
1
vote
2answers
440 views

how to find out how long the last DBCC checkdb took to complete?

In most of my servers I have dbcc checkdb scheduled to run. I can get the last known good DBCC Checkdb through DBCC DBINFO(). I can read the tracks left on the sql server log and I get something ...
0
votes
2answers
92 views

Help error message inside dynamic T-SQL

I have a requirement to come up with reporting for indexes for our whole production environment: I found the below script online and modified it according to my requirement and trying to execute it ...
0
votes
2answers
1k views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
0
votes
1answer
93 views

MariaDB Master / Slave failover / failback automation

Good day all, I'm hoping someone might be able to point me in the right direction. I'm working on a new dual data center project, and I'm trying to come up with a plan for failover (for patching and ...
0
votes
0answers
14 views

Possible to automate updating development database on a VM?

Using MySQL 5.6 and VM Workstation Pro 12.1.1. At my job, the way things are set up is that my development environment is a locally hosted Virtual Machine. Every day the first thing I need to do is ...
0
votes
1answer
67 views

Application/MS SQL Server Express Installer

We're developing a small(ish) application that collects and stores data. It's low-throughput, low-volume, but needs to be able to archive and retrieve data from (almost) arbitrarily earlier times, ...
4
votes
2answers
2k views

how to script out the user defined table types?

I can Get name and definition of all table types using either of the following scripts: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED IF OBJECT_ID('TEMPDB..#RADHE') IS NOT NULL DROP TABLE #...
2
votes
1answer
39 views

How to use grouping sets in this query that shows database sizes - adding the last time it was updated

I have the following query that shows me the database sizes, including log dna data files. SELECT [Database Name] = DB_NAME(s.database_id), [Type] = CASE WHEN s.Type_Desc = 'ROWS' THEN 'Data ...
0
votes
1answer
121 views

how to script server side permissions - specifically EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER?

I could not script the following server side permissions: GRANT VIEW DEFINITION ON LOGIN::[site_helpdesk] TO [Radhe] but thanks to the question below I found a solution to that: How to script out ...
2
votes
1answer
476 views

How to automate the changes of parameters in ssis package run by a job?

I have a job that runs a package with specific parameters as you can see on the picture below: I want to set up those parameters (the 2 dates in yellow) to 1900-01-01 instead of 2019-02-27. I need ...
1
vote
1answer
391 views

How to automate basic ddl scripts execution and management [closed]

Looking for suggestions (A Script, third party tool, software etc.) which can help automate some of the administration tasks around execution of DDL scripts across environments. Database is usually ...
0
votes
2answers
58 views

Delete old records based on its identifier

For example, I have a table similar to this: deviceid | servertime 1 2019-05-13 12:00:00 1 2019-05-14 12:00:00 2 2019-05-13 13:00:00 2 2019-05-12 13:00:00 2 ...
3
votes
2answers
961 views

updating statistics using STATS_STREAM or WITH FULLSCAN?

the syntax for creating statistics is: -- Syntax for SQL Server and Azure SQL Database UPDATE STATISTICS table_or_indexed_view_name [ { { index_or_statistics__name ...
2
votes
1answer
360 views

Having the backup file, how to work out the total disk space required to do the restore?

I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files. what I don't have is an estimate of the total backup size (for each of ...
0
votes
2answers
50 views

Looking for recommendation [closed]

I am a non IT background, my recent projects uses PowerShell for a lot of SQL Server administration. I would like to start from absolute zero, and learn to use and code the Windows PowerShell as it ...
0
votes
0answers
21 views

Syncing DDL accross Postgres shards

Our database writing needs exceed the capacity of a single Postgres cluster (since each cluster can only support 1 writer server). To combat this, we've sharded our data across 8 separate Postgres ...
1
vote
1answer
10k views

How to automate CSV-exports of queries in PL/SQL Developer (Oracle)?

I'm no pro in Oracle or PL/SQL Developer (I mostly use and admin mySQL and MS SQL Server). I'm not an admin of any sort, but have read access to many tables in Oracle via PL/SQL Developer. I need ...
1
vote
1answer
91 views

Get a list of Databases which were not modified with in a date range - SQL server [closed]

can we get an output for list of databases which were not modified for last two months in a server and based on that we have to delete all of them. I have tried below is the query: --identify when a ...
1
vote
1answer
123 views

How to upgrade a MySQL database using numbered scripts based on a version field

I have a database that contains a version table with one value stored in it which is the database version number. I would like to be able to update the database version automatically using numbered ...
1
vote
1answer
142 views

PostgreSQL - automating database grants [closed]

We're managing about 200 instances of postgres on Amazon RDS. The problem that we're constantly experiencing is that our "DBA" accounts can't access stuff. Basic stuff. Tables, views, etc. Is there ...
1
vote
3answers
5k views

How can I use Invoke-SqlCmd with variables to output the SQL command only or some similar method?

I have a big *.sql file that I run with Invoke-Sqlcmd and variables to do some tasks, and when I have an issue, it's a pain to debug because of the variables and I want to do logging of the SQL script ...
1
vote
0answers
150 views

Data warehousing (ETL): Scheduled data migration from MySQL to PostgreSQL

I've been assigned task of data warehousing for Reporting and data analysis. Let me first explain what we are going to do. Step 1. Replicate production server MySQL database. Step 2. Scheduled ETL: ...
0
votes
2answers
7k views

T-SQL: How create job that run monthly

I already know how to schedule monthly jobs using SQL Server Agent > Jobs, I now would like to learn how to schedule such job using T-SQL. I know how to schedule a job daily at a specific time: ...
0
votes
1answer
396 views

Alternate of trigger in SQL server

is there any other way beside creating a trigger in MSDB system tables to invoke a particular job when any job failed? Basically, I want a particular job ran automatically only if any of the other ...