<?xml version='1.0' encoding='Shift_JIS'?>
<!--
 ******************************************************************** 
 sticker sample
 
 transfer : remote database -> another remote database 
  
 ******************************************************************** 
-->
<sticker version="0.01" debug="true">
	<debug>Server definition</debug>
	<servers>
		<server name="your-server" driver="driver name"
			url="jdbc url" user="your name"
			pass="password" autocommit="false" />
		<server name="another-server" driver="driver name"
			url="jdbc url" user="your name"
			pass="password" autocommit="false" />
	</servers>

	<!-- local db(hsqldb) definition -->
	<tables>
		<table name="local_emp_table">
			<column name="emp_no" type="integer" nullable="false" />
			<column name="name" type="varchar(10)" nullable="false" />
			<column name="division_cd" type="integer" nullable="false" />
			<column name="sex" type="varchar(5)" nullable="false" />
			<column name="deleted" type="boolean" nullable="false" />
		</table>
	</tables>

	<debug>export to local db</debug>
	<connect name="your-server">
		<debug>employee_table-->local db</debug>
		<export destination="local_emp_table" target="remote" fileCharset="UTF8">
			select * from employee_table where deleted='false';
		</export>
	</connect>
	<debug>export to local db success</debug>

	<debug>import to another db</debug>
	<connect name="another-server">
		<import source="local_emp_table"
				destination="another_employee_table"
				fileCharset="UTF8" />
	</connect>
	<debug>import to another db success</debug>

	<!-- exception definition -->
	<exception>
		<debug>process failure!</debug>
	</exception>
</sticker>