Tag Info

New answers tagged

0

Probably you want to try PowerShell scripting for this. Previous discussion here Example


0

I know that Red Gate SQL compare has a command line interface so you could write and schedule a batch file to generate the scripts. Details here You could then use SQLcmd to execute the scripts.


1

You can specify your queries per table with the QUERY parameter with Data Pump export. For example: QUERY=employees:"WHERE department_id > 10 AND salary > 10000" With the above, only those rows are exported from the employees table, that have department_id > 10 AND salary > 10000. More information in the official documentation: ...


0

SQL*Developer is a decent tool for this, but can still take some time. If you're looking at SQL Plus, I'd recommend that you use spool, and make liberal use of SQL Plus's set command to format your output into flat files. For delimiting the flat files, you can make use of the concatenate feature to add in column headers. Here's an example: select ...


1

You can create a simple SSIS package: Here's a high-level how to: Create a OLEDB connection to the database in the connection manager Drag a Data Flow Transformation into the Control Flow and then click on it to get to the data flow. Drag a OLEDB Source from the toolbox into the data flow, and edit it so it connects to your desired table using the ...


1

You should create two mysqldumps Schema Only, No Data Data Only, No Schema Using sed, mysqldump all databases except information_schema, mysql, performance_schema Create a script with the following commands MYSQL_USER=root MYSQL_PASS=rootpassword MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}" SQL="SELECT GROUP_CONCAT(schema_name) FROM ...


0

Right click and generate scripts, then change the name of the database to target (USE db). Explained here



Top 50 recent answers are included