Questions tagged [automation]

The tag has no usage guidance.

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
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
11 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 ...
1
vote
1answer
88 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
0answers
133 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
0answers
249 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
+50

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
0answers
13 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
76 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
1answer
31 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
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
19 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
votes
1answer
736 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;...