magicexport.xml

windows下各种数据转换工具

	</SourceDB>
	<SourceDB Name="SourceDb_Northwind" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind" DbType="2">
		<SourceTable SqlStatement="SELECT * FROM Categories" Name="Categories">
			<SourceField FieldCode="CategoryID" FieldName="CategoryID" DataType="INTEGER" PrimaryKey="0" DataSize="4" IsNull="0"/>
			<SourceField FieldCode="CategoryName" FieldName="CategoryName" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="0"/>
			<SourceField FieldCode="Description" FieldName="Description" DataType="TEXT" PrimaryKey="0" DataSize="1073741823" IsNull="1"/>
			<SourceField FieldCode="Picture" FieldName="Picture" DataType="BINARY" PrimaryKey="0" DataSize="2147483647" IsNull="1"/>
			<DestinationDB Name="MyTestDb" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
				<DestinationTable TableCode="Categories" TableName="" SQLScript="" Trigger="0">
					<MapItem FieldCode="CategoryID" MapField="CategoryID" FieldName="CategoryID" DataType="INTEGER" DataSize="4" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CategoryName" MapField="CategoryName" FieldName="CategoryName" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Description" MapField="Description" FieldName="Description" DataType="TEXT" DataSize="1073741823" 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>
			<DestinationDB Name="MyAccessDb" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\MyProject\MagicCollector\Debug\MagicCollector.mdb;Persist Security Info=False" DbType="1">
				<DestinationTable TableCode="Categories" TableName="" SQLScript="DROP TABLE Categories;

CREATE TABLE Categories (
	CategoryID INTEGER NOT NULL,
	CategoryName VARCHAR(15) NOT NULL,
	Description MEMO NULL,
	Picture OLEOBJECT NULL,
	CONSTRAINT PK_Categories PRIMARY KEY (CategoryID)
)" Trigger="0">
					<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="15" 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="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Picture" MapField="Picture" FieldName="Picture" DataType="BINARY" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
			<DestinationDB Name="MyOraDb" ConnectionString="Provider=OraOLEDB.Oracle.1;Password=sqc;Persist Security Info=True;User ID=sqcuser;Data Source=sqcdemo" DbType="3">
				<DestinationTable TableCode="Categories" TableName="" SQLScript="CREATE TABLE Categories (
	CategoryID NUMBER(38) NOT NULL,
	CategoryName VARCHAR2(15) NOT NULL,
	Description CLOB NULL,
	Picture BLOB NULL,
	CONSTRAINT PK_Categories PRIMARY KEY (CategoryID)
)" Trigger="0">
					<MapItem FieldCode="CategoryID" MapField="CategoryID" FieldName="CategoryID" DataType="INTEGER" DataSize="4" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CategoryName" MapField="CategoryName" FieldName="CategoryName" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Description" MapField="Description" FieldName="Description" DataType="TEXT" DataSize="1073741823" 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 Customers" Name="Customers">
			<SourceField FieldCode="CustomerID" FieldName="CustomerID" DataType="STRING" PrimaryKey="0" DataSize="5" IsNull="0"/>
			<SourceField FieldCode="CompanyName" FieldName="CompanyName" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="ContactName" FieldName="ContactName" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="1"/>
			<SourceField FieldCode="ContactTitle" FieldName="ContactTitle" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="1"/>
			<SourceField FieldCode="Address" FieldName="Address" DataType="STRING" PrimaryKey="0" DataSize="60" IsNull="1"/>
			<SourceField FieldCode="City" FieldName="City" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<SourceField FieldCode="Region" FieldName="Region" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<SourceField FieldCode="PostalCode" FieldName="PostalCode" DataType="STRING" PrimaryKey="0" DataSize="10" IsNull="1"/>
			<SourceField FieldCode="Country" FieldName="Country" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<SourceField FieldCode="Phone" FieldName="Phone" DataType="STRING" PrimaryKey="0" DataSize="24" IsNull="1"/>
			<SourceField FieldCode="Fax" FieldName="Fax" DataType="STRING" PrimaryKey="0" DataSize="24" IsNull="1"/>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM Orders" Name="Orders">
			<SourceField FieldCode="OrderID" FieldName="OrderID" DataType="INTEGER" PrimaryKey="1" DataSize="4" IsNull="0"/>
			<SourceField FieldCode="CustomerID" FieldName="CustomerID" DataType="STRING" PrimaryKey="0" DataSize="5" IsNull="1"/>
			<SourceField FieldCode="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" PrimaryKey="0" DataSize="4" IsNull="1"/>
			<SourceField FieldCode="OrderDate" FieldName="OrderDate" DataType="DATETIME" PrimaryKey="0" DataSize="16" IsNull="1"/>
			<SourceField FieldCode="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" PrimaryKey="0" DataSize="16" IsNull="1"/>
			<SourceField FieldCode="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" PrimaryKey="0" DataSize="16" IsNull="1"/>
			<SourceField FieldCode="ShipVia" FieldName="ShipVia" DataType="INTEGER" PrimaryKey="0" DataSize="4" IsNull="1"/>
			<SourceField FieldCode="Freight" FieldName="Freight" DataType="DOUBLE" PrimaryKey="0" DataSize="8" IsNull="1"/>
			<SourceField FieldCode="ShipName" FieldName="ShipName" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="1"/>
			<SourceField FieldCode="ShipAddress" FieldName="ShipAddress" DataType="STRING" PrimaryKey="0" DataSize="60" IsNull="1"/>
			<SourceField FieldCode="ShipCity" FieldName="ShipCity" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<SourceField FieldCode="ShipRegion" FieldName="ShipRegion" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<SourceField FieldCode="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" PrimaryKey="0" DataSize="10" IsNull="1"/>
			<SourceField FieldCode="ShipCountry" FieldName="ShipCountry" DataType="STRING" PrimaryKey="0" DataSize="15" IsNull="1"/>
			<DestinationDB Name="MyAccessDb" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\MyProject\MagicCollector\Debug\MagicCollector.mdb;Persist Security Info=False" DbType="1">
				<DestinationTable TableCode="Orders" TableName="" SQLScript="CREATE TABLE Orders (
	CustomerID VARCHAR(5) NULL,
	EmployeeID INTEGER NULL,
	Freight DOUBLE NULL,
	OrderDate DATETIME NULL,
	OrderID INTEGER NOT NULL,
	RequiredDate DATETIME NULL,
	ShipAddress VARCHAR(60) NULL,
	ShipCity VARCHAR(15) NULL,
	ShipCountry VARCHAR(15) NULL,
	ShipName VARCHAR(40) NULL,
	ShippedDate DATETIME NULL,
	ShipPostalCode VARCHAR(10) NULL,
	ShipRegion VARCHAR(15) NULL,
	ShipVia INTEGER NULL,
	CONSTRAINT PK_Orders PRIMARY KEY (OrderID)
)" Trigger="0">
					<MapItem FieldCode="CustomerID" MapField="CustomerID" FieldName="CustomerID" DataType="STRING" DataSize="5" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="EmployeeID" MapField="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Freight" MapField="Freight" FieldName="Freight" DataType="DOUBLE" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="OrderDate" MapField="OrderDate" FieldName="OrderDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="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="RequiredDate" MapField="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipAddress" MapField="ShipAddress" FieldName="ShipAddress" DataType="STRING" DataSize="60" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCity" MapField="ShipCity" FieldName="ShipCity" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCountry" MapField="ShipCountry" FieldName="ShipCountry" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipName" MapField="ShipName" FieldName="ShipName" DataType="STRING" DataSize="40" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShippedDate" MapField="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipPostalCode" MapField="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" DataSize="10" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipRegion" MapField="ShipRegion" FieldName="ShipRegion" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipVia" MapField="ShipVia" FieldName="ShipVia" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
	</SourceDB>
</MagicExport>