Copying Table Via Batch

[rtk]

I have a table that is automatically created after using sja to import and then running a create table query on my local machine runnin MySQL. I've been manually copying this table to my internet hosted Mysql database, deleting the old mysql table on the internet and renaming the new table to match the old one.

So the process is

1. create the table “products1”

2. copy products1 to isp

3. delete old table products

4. rename products1 to products

Is there a way to do this automatically via sja?

Thanks.

[Mahesh]

No. Currently SJA will not do operation like mentioned in the post.

SJA will be useful in case of “Data Synchonization” , “Scheduled backup”, “Import External data”, “Notification Services” .

[Author]

Posts