登录 | 注册 | FAQ
Anonymous

миграция баз данных SQL to Mysql данные

+ 发表回复

2 篇帖子 分页: 1 / 1


миграция баз данных SQL to Mysql данные

sergey7984 » 周三 7月 04, 2012 5:27 am

Если кто захочет посмотреть скрипт в XAMPP,
что бы не возиться привожу использованные данные .
代码: 全选
<?xml version="1.0" encoding="UTF-8"?>
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:od="urn:schemas-microsoft-com:officedata">
<xsd:schema>
<xsd:element name="dataroot">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="tab1" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
<xsd:attribute name="generated" type="xsd:dateTime"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="tab1">
<xsd:annotation>
<xsd:appinfo>
<od:tableProperty name="GUID" type="9" value="JvTnT03/wESsGlh00sWUAg==
"/>
<od:tableProperty name="Orientation" type="2" value="0"/>
<od:tableProperty name="OrderByOn" type="1" value="0"/>
<od:tableProperty name="NameMap" type="11" value="CswOVQAAAAAm9OdPTf/ARKwaWHTSxZQCAAAAAKny2lPAEORAAAAAAAAAAAB0AGEA
YgAxAAAAAAAAAP5p3BjuMo9MgxszRtlgT8UHAAAAJvTnT03/wESsGlh00sWUAkEA
ZABkAHIAZQBzAHMASQBEAAAAAAAAAE4CHk7Y5xpNvvwkFkc6aZoHAAAAJvTnT03/
wESsGlh00sWUAkEAZABkAHIAZQBzAHMATABpAG4AZQAxAAAAAAAAAMC5QhlU+zVP
v5ObfLyKWQIHAAAAJvTnT03/wESsGlh00sWUAkEAZABkAHIAZQBzAHMATABpAG4A
ZQAyAAAAAAAAAHpVN4bGsIlDsI6n+2+PCWwHAAAAJvTnT03/wESsGlh00sWUAkMA
aQB0AHkAAAAAAAAAOozWdm0mDUW5WY7zGNCAEAcAAAAm9OdPTf/ARKwaWHTSxZQC
UwB0AGEAdABlAFAAcgBvAHYAaQBuAGMAZQBJAEQAAAAAAAAAWCXaRLO8J0Ow64SW
7eol8wcAAAAm9OdPTf/ARKwaWHTSxZQCUABvAHMAdABhAGwAQwBvAGQAZQAAAAAA
AACSt2gNvvTfRZtASkSSyWp6BwAAACb0509N/8BErBpYdNLFlAJyAG8AdwBnAHUA
aQBkAAAAAAAAABttFLVDZvxLlb1lbJ4EpAEHAAAAJvTnT03/wESsGlh00sWUAk0A
bwBkAGkAZgBpAGUAZABEAGEAdABlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMAAAA
BQAAAAAAAAAAAAAAAAAAAAAA
"/>
<od:tableProperty name="DefaultView" type="2" value="2"/>
<od:tableProperty name="DisplayViewsOnSharePointSite" type="2" value="1"/>
<od:tableProperty name="TotalsRow" type="1" value="0"/>
<od:tableProperty name="FilterOnLoad" type="1" value="0"/>
<od:tableProperty name="OrderByOnLoad" type="1" value="1"/>
<od:tableProperty name="HideNewField" type="1" value="0"/>
<od:tableProperty name="BackTint" type="6" value="100"/>
<od:tableProperty name="BackShade" type="6" value="100"/>
<od:tableProperty name="ThemeFontIndex" type="4" value="-1"/>
<od:tableProperty name="AlternateBackThemeColorIndex" type="4" value="-1"/>
<od:tableProperty name="AlternateBackTint" type="6" value="100"/>
<od:tableProperty name="AlternateBackShade" type="6" value="100"/>
<od:tableProperty name="DatasheetGridlinesThemeColorIndex" type="4" value="-1"/>
<od:tableProperty name="DatasheetForeThemeColorIndex" type="4" value="-1"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="AddressID" minOccurs="1" od:jetType="autonumber" od:sqlSType="int" od:autoUnique="yes" od:nonNullable="yes" type="xsd:int">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="/mncGO4yj0yDGzNG2WBPxQ==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="AddressLine1" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="TgIeTtjnGk2+/CQWRzppmg==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="AllowZeroLength" type="1" value="1"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="IMEMode" type="2" value="0"/>
<od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
<od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="60"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AddressLine2" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="wLlCGVT7NU+/k5t8vIpZAg==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="AllowZeroLength" type="1" value="1"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="IMEMode" type="2" value="0"/>
<od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
<od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="60"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="City" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="elU3hsawiUOwjqf7b48JbA==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="AllowZeroLength" type="1" value="1"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="IMEMode" type="2" value="0"/>
<od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
<od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="30"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="StateProvinceID" minOccurs="0" od:jetType="longinteger" od:sqlSType="int" type="xsd:int">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="OozWdm0mDUW5WY7zGNCAEA==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="DecimalPlaces" type="2" value="255"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="PostalCode" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="WCXaRLO8J0Ow64SW7eol8w==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="AllowZeroLength" type="1" value="1"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="IMEMode" type="2" value="0"/>
<od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
<od:fieldProperty name="UnicodeCompression" type="1" value="1"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="15"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="rowguid" minOccurs="0" od:jetType="replicationid" od:sqlSType="uniqueidentifier">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="krdoDb7030WbQEpEkslqeg==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="DisplayControl" type="3" value="109"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="38"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ModifiedDate" minOccurs="0" od:jetType="datetime" od:sqlSType="datetime" type="xsd:dateTime">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="GUID" type="9" value="G20UtUNm/EuVvWVsngSkAQ==
"/>
<od:fieldProperty name="ColumnWidth" type="3" value="-1"/>
<od:fieldProperty name="ColumnOrder" type="3" value="0"/>
<od:fieldProperty name="ColumnHidden" type="1" value="0"/>
<od:fieldProperty name="Required" type="1" value="0"/>
<od:fieldProperty name="IMEMode" type="2" value="0"/>
<od:fieldProperty name="IMESentenceMode" type="2" value="3"/>
<od:fieldProperty name="TextAlign" type="2" value="0"/>
<od:fieldProperty name="AggregateType" type="4" value="-1"/>
<od:fieldProperty name="ShowDatePicker" type="3" value="1"/>
<od:fieldProperty name="ResultType" type="2" value="0"/>
<od:fieldProperty name="CurrencyLCID" type="4" value="0"/>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<dataroot xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" generated="2012-07-04T00:16:34">
<tab1>
<AddressID>1</AddressID>
<AddressLine1>1970 Napa Ct.</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{9AADCB0D-36CF-483F-84D8-585C2D4EC6E9}</rowguid>
<ModifiedDate>1998-01-04T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>2</AddressID>
<AddressLine1>9833 Mt. Dias Blv.</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{32A54B9E-E034-4BFB-B573-A71CDE60D8C0}</rowguid>
<ModifiedDate>1999-01-01T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>3</AddressID>
<AddressLine1>7484 Roundtree Drive</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{4C506923-6D1B-452C-A07C-BAA6F5B142A4}</rowguid>
<ModifiedDate>2003-04-08T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>4</AddressID>
<AddressLine1>9539 Glenside Dr</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{E5946C78-4BCC-477F-9FA1-CC09DE16A880}</rowguid>
<ModifiedDate>1999-03-07T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>5</AddressID>
<AddressLine1>1226 Shoe St.</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{FBAFF937-4A97-4AF0-81FD-B849900E9BB0}</rowguid>
<ModifiedDate>1999-01-20T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>6</AddressID>
<AddressLine1>1399 Firestone Drive</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{FEBF8191-9804-44C8-877A-33FDE94F0075}</rowguid>
<ModifiedDate>1999-03-17T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>7</AddressID>
<AddressLine1>5672 Hale Dr.</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{0175A174-6C34-4D41-B3C1-4419CD6A0446}</rowguid>
<ModifiedDate>2000-01-12T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>8</AddressID>
<AddressLine1>6387 Scenic Avenue</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{3715E813-4DCA-49E0-8F1C-31857D21F269}</rowguid>
<ModifiedDate>1999-01-18T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>9</AddressID>
<AddressLine1>8713 Yosemite Ct.</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{268AF621-76D7-4C78-9441-144FD139821A}</rowguid>
<ModifiedDate>2002-07-01T00:00:00</ModifiedDate>
</tab1>
<tab1>
<AddressID>10</AddressID>
<AddressLine1>250 Race Court</AddressLine1>
<City>Bothell</City>
<StateProvinceID>79</StateProvinceID>
<PostalCode>98011</PostalCode>
<rowguid>{0B6B739D-8EB6-4378-8D55-FE196AF34C04}</rowguid>
<ModifiedDate>1999-01-03T00:00:00</ModifiedDate>
</tab1>
</dataroot>
</root>

头像

sergey7984

  • 帖子: 54
  • 注册: 周二 12月 20, 2011 5:25 pm

Re: миграция баз данных SQL to Mysql данные

XainPro » 周三 11月 28, 2012 8:41 am

а вы не можете напрямую импортировать этот тип данных в MySQL первом вам нужно конвертировать его в SQL Есть много программного обеспечения доступна для Преобразование XML в SQL вы должны попробовать любой бесплатной.
вот одна программа, которая может сделать вашу работу
http://www.xml-converter.com/
头像

XainPro

  • 帖子: 3933
  • 注册: 周五 2月 17, 2012 8:10 pm


+ 发表回复

分页: 1 / 1