Cov txheej txheem:

Kuv yuav export database los ntawm DbVisualizer li cas?
Kuv yuav export database los ntawm DbVisualizer li cas?

Video: Kuv yuav export database los ntawm DbVisualizer li cas?

Video: Kuv yuav export database los ntawm DbVisualizer li cas?
Video: kuv txiv siab phem - Koos Loos 2024, Kaum ib hlis
Anonim

Qhov no feature tsuas yog muaj nyob rau hauv lub DbVisualizer Pro tsab.

Export ib schema:

  1. Xaiv tus schema node hauv Cov ntaub ntawv tab tree,
  2. Tua tawm lub Export Schema pab los ntawm txoj cai-nias ntawv qhia zaub mov,
  3. Xaiv ib hom ntawv tso zis, tso zis qhov chaw, yam khoom rau xa tawm thiab xaiv,
  4. Nyem Export .

Yog li ntawd, kuv yuav export ib database schema li cas?

Export schema qauv siv SQLYog

  1. Los ntawm cov cuab yeej ntawv qhia zaub mov, xaiv Backup Database li SQL pob tseg.
  2. Nyob rau sab saum toj pane, xaiv Export li SQL: qauv nkaus xwb.
  3. Nyob rau sab laug, xaiv lub database rau export.
  4. Nyob rau sab laug, uncheck tag nrho cov hom khoom tshwj tsis yog Tables.
  5. Uncheck tag nrho cov kev xaiv ntawm sab xis pane.
  6. Nyem Export.

Ib yam li ntawd, export schema yog dab tsi? Cov Export Schema /Database feature yog siv rau xa tawm lub DDL rau cov khoom xws li rooj, views, txheej txheem, functions, triggers, pob khoom thiab pob lub cev. Lub hom phiaj lub hom phiaj tuaj yeem yog ib qho ntawm cov ntaub ntawv, ntawv teev cia lossis SQL Commander editor. Koj ua tau xa tawm txhua yam khoom lossis tsuas yog xaiv.

Ib yam li ntawd, nws tau nug, Kuv yuav import cov ntaub ntawv Excel rau hauv DbVisualizer li cas?

Cov kauj ruam yog yuav luag zoo tib yam:

  1. Xaiv lub rooj ntawm lub rooj koj xav import rau, lossis Tables node yog tias koj tab tom importing rau lub rooj tshiab, hauv Databases tab ntoo,
  2. Qhib cov Ntshuam Table Data wizard los ntawm txoj cai-nias ntawv qhia zaub mov,
  3. Qhia meej cov ntaub ntawv nkag rau ntawm thawj nplooj ntawv wizard (CSV lossis Excel file),

Yuav ua li cas koj tsim ib daim ntawv sau hauv DbVisualizer?

Txhawm rau qhib Script Table dialog, qhov twg koj tuaj yeem ntxig cov ntawv tsim rau lub rooj hauv SQL Commander editor:

  1. Xaiv ib lossis ntau lub rooj nodes hauv Databases tab ntoo,
  2. Xaiv Script Table los ntawm txoj cai-nias ntawv qhia zaub mov.

Pom zoo: