Cov txheej txheem:

Microsoft Data Migration Assistant yog dab tsi?
Microsoft Data Migration Assistant yog dab tsi?

Video: Microsoft Data Migration Assistant yog dab tsi?

Video: Microsoft Data Migration Assistant yog dab tsi?
Video: Night 2024, Hlis ntuj nqeg
Anonim

Txheej txheem cej luam. Cov Data Migration Assistant (DMA) tso cai rau koj hloov mus rau qhov niaj hnub cov ntaub ntawv platform los ntawm kev txheeb xyuas cov teeb meem kev sib raug zoo uas tuaj yeem cuam tshuam database functionality ntawm koj tus tshiab version ntawm SQL Server. Cov cuab yeej qhia txog kev ua tau zoo thiab kev txhim kho kev ntseeg siab rau koj lub hom phiaj ib puag ncig.

Ib yam li ntawd, tib neeg nug, peb cov ntaub ntawv tsiv teb tsaws chaw muaj dab tsi?

Hauv qab no yog ib daim ntawv teev npe nrov ntawm cov ntaub ntawv hauv qhov chaw tsiv teb tsaws:

  • Centerprise Data Integrator.
  • IBM InfoSphere.
  • Informatica PowerCenter.
  • Microsoft SQL.
  • Oracle Data Service Integrator.
  • Talend Data Integration.

Ib yam li ntawd, kuv yuav migrate database li cas? Yuav kom migrate lub database, muaj ob kauj ruam:

  1. Kauj Ruam Ib-Ua rau MySQL Dump. Ua ntej xa cov ntaub ntawv database mus rau VPS tshiab, peb yuav tsum xub rov qab nws ntawm tus thawj virtual server los ntawm kev siv mysqldump hais kom ua.
  2. Kauj Ruam Ob-Copy Database. SCP pab koj luam cov ntaub ntawv.
  3. Kauj ruam 3-Ntshuam lub Database.

Tsis tas li ntawd, cov ntaub ntawv tsiv teb tsaws hauv SQL Server yog dab tsi?

Hauv tsab xov xwm no, kuv yuav piav qhia txog ntau txoj hauv kev rau tsiv teb tsaws Microsoft SQL Server databases nruab nrab servers los yog piv txwv. Muaj ntau qhov xwm txheej uas koj yuav tsum tau tsiv mus database los yog restore databases. Cov laj thawj feem ntau yog: Tsiv mus rau qhov tshiab nkaus xwb server . Tsiv mus rau lwm qhov piv txwv ntawm SQL ntawv.

Yuav ua li cas kom tshem tau Azure database?

Txheej txheem cej luam ntawm schema migration kauj ruam

  1. Qhib DMA, thiab tom qab ntawd pib tsim qhov project tsiv teb tsaws tshiab.
  2. Qhia meej lub npe qhov project, xaiv SQL Server raws li hom neeg rau zaub mov, thiab tom qab ntawd xaiv Azure SQL Database raws li hom phiaj neeg rau zaub mov.
  3. Qhia meej txog kev tsiv teb tsaws chaw raws li Schema nkaus xwb, thiab tom qab ntawd tsim qhov project.

Pom zoo: