Odbc Import – Local Append

[shawn_h]

I recently purchased SQLyog Enterprise and pretty happy with it too. However, I'd like to do the following on multiple databases:

1-using ODBC Import wizard

2-Specify the columns that I want to import and map

3-add (or append) a column to the table currently being imported

4-assign a default as a value to the above column

5-so this means one additional column with a default value for each and every row imported

Let me say that the regular importing works fine; however, I want to be able to add this one column with a default value to the table that is being imported.

I'd imagine this should be doable by manipulating the job file.

Any help is greatly apreciated.

-s

[peterlaursen]

Quote:

I want to be able to add this one column with a default value to the table that is being imported.

The solution is the have two jobs

1) An ODBC-importjob

2) A Notifications Service-Job executing the appropriate ALTER TABLE statement.

You can then build a job.bat file like

Quote:

SJA importjob.xml

SJA notifyjob.xml

and the job.bat can be executed or scheduled.

As of now there is no way to execute more job type from one jobfile and you can't either add additional data to the MySQL database with an ODBC-import-job.

[shawn_h]

I see!

So if we're talking about say 10 tables, then we're talking about 10 import jobs and 10 notification jobs, executed serially, one after the other. Is that right?

Do you have an example I can use?

[peterlaursen]

You have a Personal Message with a download link.

Peter

[Author]

Posts