Questions tagged [automation]

The tag has no usage guidance.

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
66 views

MySQL Shell Python Client library

Is there a python client library available to interact with MySQL Admin API and to do similar stuff that MySQL Shell does. From the documentation of MySQL Shell, I could see that there is a --py mode ...
1
vote
0answers
121 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: ...
1
vote
1answer
2k views

How to configure AutoMySQLBackup?

How I can configure AutoMySQLBackup to backup some selected tables ones per week while the other tables will be backed up every day? Thanks. P.S. My google search ninja skills is not working. :)
1
vote
0answers
235 views

Can you script the MDS database upgrade after SQL Patch applied

I have recently automated the SQL patching of ~200 development servers. Currently we have 6 servers that run the Microsoft Master Data Services feature. After a SQL patch is applied there is a ...
1
vote
0answers
1k views

Start/stop postgresql with pg_ctl or service without root access on RHEL6

We plan to use postgresql on RHEL 6. DBAs won't have root access but they will need to start/stop the databases. They'll be able to do so with pg_ctl as postgres. However databases should also start ...
0
votes
0answers
10 views

SQL Azure Datawarehouse Automation Tasks

Today I had to create 3 LOGIN, 3 role, a 6 schema on Datawarehouse. It took 1 hour and 177 Lines of code, it's too much don't you think? CREATE LOGIN [CUSTOMER_BATCH_DEV] with password = '**********...
0
votes
0answers
9 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 ...
0
votes
0answers
8 views

Is there some parameter/flag I can use to make pgAdmin 4 update silently without the GUI?

Every single time pgAdmin 4 has an update, I have made it so that it grabs the latest installer (this is on Windows) and puts it on my desktop, then notifies me. I then have to manually run this GUI ...
0
votes
1answer
30 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) ...
0
votes
1answer
37 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
0answers
18 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 ...
0
votes
1answer
77 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
votes
1answer
674 views

How to write the bash scripts with automatic function in postgresql?

To save the bash as create_mysql.sh, we can create a database magento and a user magento_user with full privileges by password. mysqlword="xyzzy" mysql -u root -p$mysqlword -e"CREATE DATABASE magento;...