magicexport.xml

windows下各种数据转换工具

<?xml version="1.0" encoding="GBK"?>
<MagicExport>
	<SourceDB Name="SourceDb1" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
		<SourceTable SqlStatement="SELECT * FROM Categories" Name="Categories">
			<SourceField FieldCode="CategoryID" FieldName="CategoryID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="CategoryName" FieldName="CategoryName" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="Description" FieldName="Description" DataType="TEXT" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="Picture" FieldName="Picture" DataType="BINARY" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<DestinationDB Name="" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="0">
				<DestinationTable TableCode="CategoriesTest" TableName="" SQLScript="" Trigger="1">
					<MapItem FieldCode="CategoryID" MapField="CategoryID" FieldName="CategoryID" DataType="INTEGER" DataSize="0" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CategoryName" MapField="CategoryName" FieldName="CategoryName" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Description" MapField="Description" FieldName="Description" DataType="TEXT" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Picture" MapField="Picture" FieldName="Picture" DataType="BINARY" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM Orders" Name="Orders">
			<SourceField FieldCode="OrderID" FieldName="OrderID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="CustomerID" FieldName="CustomerID" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="OrderDate" FieldName="OrderDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipVia" FieldName="ShipVia" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="Freight" FieldName="Freight" DataType="DOUBLE" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipName" FieldName="ShipName" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipAddress" FieldName="ShipAddress" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipCity" FieldName="ShipCity" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipRegion" FieldName="ShipRegion" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipCountry" FieldName="ShipCountry" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<DestinationDB Name="" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="0">
				<DestinationTable TableCode="OrdersTest" TableName="" SQLScript="" Trigger="1">
					<MapItem FieldCode="OrderID" MapField="OrderID" FieldName="OrderID" DataType="INTEGER" DataSize="0" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CustomerID" MapField="CustomerID" FieldName="CustomerID" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="EmployeeID" MapField="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="OrderDate" MapField="OrderDate" FieldName="OrderDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="RequiredDate" MapField="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShippedDate" MapField="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipVia" MapField="ShipVia" FieldName="ShipVia" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Freight" MapField="Freight" FieldName="Freight" DataType="DOUBLE" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipName" MapField="ShipName" FieldName="ShipName" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipAddress" MapField="ShipAddress" FieldName="ShipAddress" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCity" MapField="ShipCity" FieldName="ShipCity" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipRegion" MapField="ShipRegion" FieldName="ShipRegion" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipPostalCode" MapField="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCountry" MapField="ShipCountry" FieldName="ShipCountry" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM Products" Name="Products">
			<SourceField FieldCode="ProductID" FieldName="ProductID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ProductName" FieldName="ProductName" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="SupplierID" FieldName="SupplierID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="CategoryID" FieldName="CategoryID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="QuantityPerUnit" FieldName="QuantityPerUnit" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="UnitPrice" FieldName="UnitPrice" DataType="DOUBLE" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="UnitsInStock" FieldName="UnitsInStock" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="UnitsOnOrder" FieldName="UnitsOnOrder" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ReorderLevel" FieldName="ReorderLevel" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="Discontinued" FieldName="Discontinued" DataType="BOOLEAN" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<DestinationDB Name="" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="0">
				<DestinationTable TableCode="ProductsTest" TableName="" SQLScript="" Trigger="1">
					<MapItem FieldCode="ProductID" MapField="ProductID" FieldName="ProductID" DataType="INTEGER" DataSize="0" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ProductName" MapField="ProductName" FieldName="ProductName" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="SupplierID" MapField="SupplierID" FieldName="SupplierID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CategoryID" MapField="CategoryID" FieldName="CategoryID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="QuantityPerUnit" MapField="QuantityPerUnit" FieldName="QuantityPerUnit" DataType="STRING" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="UnitPrice" MapField="UnitPrice" FieldName="UnitPrice" DataType="DOUBLE" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="UnitsInStock" MapField="UnitsInStock" FieldName="UnitsInStock" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="UnitsOnOrder" MapField="UnitsOnOrder" FieldName="UnitsOnOrder" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ReorderLevel" MapField="ReorderLevel" FieldName="ReorderLevel" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Discontinued" MapField="Discontinued" FieldName="Discontinued" DataType="BOOLEAN" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM CategoriesTest" Name="CategoriesTest">
			<SourceField FieldCode="CategoryID" FieldName="CategoryID" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="0"/>
			<SourceField FieldCode="CategoryName" FieldName="CategoryName" DataType="STRING" PrimaryKey="0" DataSize="50" IsNull="0"/>
			<SourceField FieldCode="Description" FieldName="Description" DataType="TEXT" PrimaryKey="0" DataSize="2147483647" IsNull="0"/>
			<SourceField FieldCode="Picture" FieldName="Picture" DataType="BINARY" PrimaryKey="0" DataSize="2147483647" IsNull="0"/>
			<DestinationDB Name="MyTestDB" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
				<DestinationTable TableCode="CategoriesTest" TableName="" SQLScript="IF EXISTS (SELECT 1 FROM sysobjects WHERE id = object_id('CategoriesTest') AND type = 'U') 
 	 DROP TABLE CategoriesTest;

CREATE TABLE CategoriesTest (
	CategoryID 	NUMERIC 	NOT NULL,
	CategoryName 	VARCHAR 	NOT NULL,
	Description 	TEXT 	NULL,
	Picture 	IMAGE 	NULL,
	CONSTRAINT PK_CategoriesTest PRIMARY KEY (CategoryID)
);" Trigger="0">
					<MapItem FieldCode="CategoryID" MapField="CategoryID" FieldName="CategoryID" DataType="DOUBLE" DataSize="0" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CategoryName" MapField="" FieldName="CategoryName" DataType="STRING" DataSize="50" PrimaryKey="0" IsNull="0" FieldType="2" DefaultValue="" LookupStatement="select categoryname from categoriestest where categoryid='[categoryid]'" Parameters="categoryid" Enabled="1"/>
					<MapItem FieldCode="Description" MapField="Description" FieldName="Description" DataType="TEXT" DataSize="2147483647" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Picture" MapField="Picture" FieldName="Picture" DataType="BINARY" DataSize="2147483647" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM OrdersTest" Name="OrdersTest">
			<SourceField FieldCode="OrderID" FieldName="OrderID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="CustomerID" FieldName="CustomerID" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="OrderDate" FieldName="OrderDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipVia" FieldName="ShipVia" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="Freight" FieldName="Freight" DataType="DOUBLE" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipName" FieldName="ShipName" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipAddress" FieldName="ShipAddress" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipCity" FieldName="ShipCity" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>