Afai e te masani ile SQL Server, masalo ua e iloa le i ai o meafaigaluega eseese mo le faʻatusatusaina o faʻamaumauga. Ua leva ona i ai ma ua faʻaaogaina e faʻatusatusa ai faʻamaumauga ina ia iloa ai eseesega i faʻamaumauga. O nei mea faigaluega e fa'aogaina e fa'atonu fa'amaumauga e va'ai pe tutusa a latou fa'amaumauga pe leai.
E mafai ona faʻaogaina e faʻamautinoa ai pe iai ni suiga o faʻamatalaga i le va o faʻamaumauga e lua, faʻapea foʻi ma le siakiina pe iai ni faʻamaumauga fou e leʻi i ai i le lomiga muamua. E mafai ona fa'aoga e fa'atino uma ai fa'atusatusaga i luma ma tua.
Siaki la matou lisi i lalo!
dbForge Fa'atusa Fa'atusa mo le SQL Server
dbForge Fa'atusatusaga Fa'amatalaga mo le SQL Server o se mea faigaluega fa'atusatusa SQL e tu'ufa'atasia ai se fa'aoga fa'aoga-fa'aoga fa'atasi ma fa'atinoga mamana. E mafai ona e filifilia le filifiliga faʻatusatusa e fetaui lelei mo oe ma faʻaaoga lena mea, e faigofie ai mo oe ona filifili le filifiliga sili, pe e te manaʻomia le totogiina o le mea saʻo. E mafai ona e va'ai suiga i se lipoti, fa'atusatusa suiga, ma fa'atino se fa'amaumauga o fa'amaumauga.
O le lisi atoa lea o foliga uma e ofoina atu e le fofo, ma o loʻo lisiina ma latou faʻamatalaga, screenshots, ma isi mea.
vaega:
- Scripts Folder Lagolago
Fa'atusatusa Fa'amatalaga mo le SQL Server e mafai ai e oe ona fa'atusatusa mea o lo'o i totonu o lau faila fa'amaumauga e fa'asaga i le fa'amaumauga o lo'o e galue ai ma iloa po'o fea suiga o fa'amaumauga e le o aofia ai i lau faufale po'o le fa'atonutonuina o le faiga. fou ma faʻatutu se fausaga faila fou. - Fa'atusatusaga Fa'asinomaga
dbForge Data Compare o se meafaigaluega mamana e mafai ona faʻatusatusa e le gata o laulau ma vaaiga ae faʻapea foʻi ma soʻo se ituaiga mea. Po'o se mea e mafai ona filifilia e fai ma Puna po'o se Taulaga. - SSMS Tuufaatasi
O lenei mea faigaluega saogalemu ma faigofie e fa'amaopoopo au fa'amaumauga SQL Server i le ao ina ia mafai ai ona e mauaina au fa'amaumauga SQL Server ma faia suiga fa'amaumauga mai so'o se mea ma so'o se masini.
Faʻamasinoga Faʻamatalaga:
- Taimi fa'ata'ita'iga - 30 aso
- So'oga fa'ata'ita'iga - SQL Faatusatusa laiga
Datanamic DataDiff
Datanamic DataDiff ose fa'aoga mamana ma faigofie-fa'aoga mo fa'atusatusaga fa'amaumauga ma fa'atasi.
E mafai ona e fa'atusatusaina fa'amaumauga mo laulau filifilia ile lua fa'amaumauga e ala ile fa'aogaina ole Microsoft SQL Server Data Compare.
vaega:
- Fa'atusatusa fanua filifilia
O le fa'amaopoopoina o fa'ato'aga ose mea fa'apitoa. E mafai ona e fa'amalamalamaina po'o fea fanua e fa'amaopoopo ae o fea e leai. Ina ia mafai ona faʻafetaui se fanua, e tatau ona e faʻaopoopo le igoa o le fanua i le Lisi o Fields e Faʻatusatusa. - Fa'amatala ki fa'atusatusaga masani
E otometi lava ona filifilia se ki fa'atusatusa mo au laulau pe a iai ki fa'atusa tulaga ese. E mafai ona e fatuina soʻo se ki faʻatusatusa e te manaʻo ai ona faʻaopoopo lea o ki faʻatusatusa i laulau faʻatusatusa. - Fesoasoani fa'amaoni fa'asino
O le Datanamic DataDiff e fa'atumauina au fa'amaumauga i feso'ota'iga e ala i le puleaina o feso'ota'iga fa'amaumauga ma le fa'amaoni fa'asino ile taimi ole fa'atusatusaga po'o le fa'atasi. Ina ia faatelevaveina le fa'amaopoopoina, o lo'o ia te oe le filifiliga e fa'amalo ai ki mai fafo i le taimi o le fa'atasi. - Lapataiga ile tulaga fa'amaumauga mo mea sese e ono tutupu ile taimi ole fa'amaopoopo
E tupu lenei mea pe afai e te fa'amaopoopoina se laulau po'o se va'aiga o lo'o i ai laina na tapeina pe fa'aopoopo i se isi laulau i le taimi o le fa'amaopoopoina.O se mea sese masani lea e tula'i mai pe a fa'aogaina fa'amatalaga DML ile SQL. O nei mea sese e ono tupu pe a o le tau o loʻo faʻaofiina o se tau NULL.
Faʻamasinoga Faʻamatalaga:
- Taimi fa'ata'ita'iga - 14 aso
- So'oga fa'ata'ita'iga - Datanamic DataDiff download
EMS Fa'atusa Fa'amatalaga mo SQL Server
E na'o le pau lea o le meafaigaluega e te mana'omia mo le fa'atusatusaga o fa'amaumauga a le SQL Server ma le fa'amaopoopoina! Faatasi ai ma se kiliki faigofie, e te maua atoatoa le vaʻaia i lau faʻamaumauga faʻamaumauga ma faʻamaumauga ma faia suiga sili atu ona lelei.
I le fa'aogaina o lenei fa'aoga, e mafai ona e va'ai i eseesega uma i le va o lau laulau fa'amaumauga, ma o le a tu'uina atu ai se fa'amaumauga otometi e fa'ate'aina nei eseesega.
O le fetuunaiga fetuutuunai o le SQL Server faatusatusaga ma synchronization faagasologa o le a mafai ai e oe ona filifili laulau ma fanua mo faatusatusaga, faatino vaega SQL Server synchronization faʻamaumauga poʻo faʻatusatusaga faʻamaumauga mo le tele o laulau i le taimi e tasi ma faʻafetaui le tele o isi filifiliga e faʻatusatusa lelei faʻamaumauga o laulau SQL Server.
vaega:
- Fa'aoga fa'aoga fa'akomepiuta
Fa'atusatusaga o Fa'amaumauga mo le SQL Server e aofia ai se fa'ata'ita'i fa'akalafi e fesoasoani e ta'ita'ia oe ile fa'agasologa ole fa'amaopoopoina o fa'amaumauga a le SQL Server. O le wizard ma le mea faigaluega laina faʻatonu e aofia ai ma le oloa e faigofie ona faʻaoga, ma e mafai ona faʻaogaina mai le komepiuta poʻo se server e pei o se galuega faʻatulagaina.
Faʻamasinoga Faʻamatalaga:
- Taimi fa'ata'ita'iga - 30 aso
- So'oga fa'ata'ita'iga - La'uina mai e Fa'atusa Fa'amaumauga
Filifili Fa'atusatusa
Afai e te fa'atusatusaina fa'amaumauga, e te fa'aogaina lelei lou taimi. O le a e iloa po'o fea fa'amaumauga e sili atu le taua nai lo isi ma po'o fea fa'amaumauga e tu'u ai. O faatusatusaga, i se tasi itu po o se isi, e aofia ai se vaega tele o o tatou olaga. E manaʻomia le faʻamaonia o faʻamaumauga mo le saʻo o le faʻaogaina o faʻamaumauga, e manaʻomia le siakiina o le faila e faʻatatau i taunuuga ETL, ma e manaʻomia ona siaki lipoti mo le saʻo.
Faatasi ai ma SelectCompare, o le ae mauaina faʻaiʻuga mai lau faʻamaumauga. Fa'aoga fa'amatalaga filifilia e tu'u'ese'ese ai fa'amaumauga ta'itasi ma fa'atulaga tu'utu'uga fa'atasi. Fa'aoga le Meafaigaluega Fa'atusatusa e a'oa'o ai le eseesega i le va o au tauva, ma le lelei ma le le lelei o mea ta'itasi, e aunoa ma le faia o se galuega.
vaega:
- Fa'atusatusaga Fa'amatalaga Faigofie
Faatusatusa faʻamatalaga mo oe - pe a e manaʻomia, mo le umi e te manaʻomia ai. Afai e te manaʻo e faʻatusatusa au faʻamatalaga pisinisi, e umi se taimi pe a e faia ma le lima. - Faatusatusa au faʻamatalaga
E le afaina fa'amaumauga pe a e fa'atusatusaina fa'amaumauga. Afai e te iloa le auala e tusi ai le code aoga, e mafai ona e faʻaogaina au faʻamatalaga. Faatasi ai ma SelectCompare, e mafai ona e tusia naʻo le lua SELECT faʻamatalaga, oomi se ki, ma SelectCompare e faʻaaogaina le vaega o totoe. E faigofie lava! Tu'u atu au fa'atusatusaga o fa'amaumauga i se fa'asologa e faigofie ona faitau ina ia fa'atusatusa e au paaga, pule, ma isi tagata uma au fa'ai'uga. E te le toe popole lava i fa'ama'i po'o isi fa'afitauli ona o lo'o iai sau su'e masini.
Faʻamasinoga Faʻamatalaga:
- Taimi fa'amasinoga - leai se fa'amasinoga
- So'otaga fa'ata'ita'iga - Fa'atusa Fa'amatalaga Fa'afaigofie
