Tag Info

New answers tagged

0

There's a good post here. I suggest that you spend some time studying this page (I'm assuinmg that you are familiar with Informix). As the first post suggests, you'll have a lot more trouble if you are migrating stored procedures - frequently there isn't a 1-to-1 correspondance between logical constructs as there can be between different datatypes. As for ...


0

You first need to convert that output file nearest to MySQL syntax and convert the data type according to MySQL. You could user perl or sed scripts for first time and then use these techniques for future use. Once you have prepared the files of table creation then generate dynamic insert statements from informix and use them in MySQL for loading data. ...


0

This is the solution I came up with: Enable xp_cmdshell with EXEC sp_configure 'show advanced options', 1 COMMIT GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 COMMIT GO RECONFIGURE GO If needed create a directory with xp_cmdshell to get the needed permissions. EXEC master..xp_cmdshell 'mkdir C:\exportdir' Use BCP with queryout EXEC ...


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