Results 1 to 13 of 13

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location: Âàðíà
    Posts: 260

    Export na MS SQL database â .sql file

    Click image for larger version. 

Name:	My sql.JPG 
Views:	104 
Size:	22.5 KB 
ID:	31843 <- Îáùîòî âçåòî òúðñÿ òàçè îïöèÿ.

    ×ðåç îïöèÿòà èì Generate Scripts ñå ïîëó÷àâà íåùî ïîäîáíî,íî sql êîäà êîéòî ñå ãåíåðèðà å ñàìî ñ òàáëèöèòå,à íå ñúñ ñàìèòå çàïèñèòå çàïèñè, êîèòî ñà âàæíèòå â ñëó÷àÿ.

    Click image for larger version. 

Name:	Generate Script.JPG 
Views:	83 
Size:	33.7 KB 
ID:	31844

    P.S :
    1.DatabasePublishingWizard
    2.SQLDumper

    Íàìåðèõ òåçè äâå ïðîãðàìè îáùîòî âçåòî ùå ñâúðøàò ðàáîòà.
    Last edited by bombov; 9th August 2010 at 20:57.

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Àêî èìàø mysql, ïðîáâàé äà åêñïîðòèðàø êúì ODBC data source, ñâúðçàí ñ mysql database, è îò mysql äà ñè åêñïîðòèðàø êúì .sql.
    Äèðåêòåí åêñïîðò êúì SQL ñêðèïò îò ñàìîòî management studio è àç íå ñúì íàìåðèë.

  3. #3
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location: Âàðíà
    Posts: 260
    Èçïîëçâàì MSDNAA MS SQL Server 2005.

    Click image for larger version. 

Name:	Step 1.JPG 
Views:	80 
Size:	37.3 KB 
ID:	31847 <- Step 1

    Click image for larger version. 

Name:	Step 2.JPG 
Views:	56 
Size:	63.0 KB 
ID:	31848 <- Step 2.

    Êàêâî òî÷íî òðÿáâà äà èçáåðà ,÷å íå âèæäàì îïöèÿ ODBC.

    Äðóãèÿ âàðèàíò, êîéòî ñå ñåòèõ å äà ãî ãåíåðèì êúì Oracle Server

  4. #4
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Êúì çà êàêâîòî èìàø ODBC äðàéâåð.
    Çà äà âèäèø mysql ODBC íåùî òàì, òðÿáâà ïúðâî äà èíñòàëèðàø mysql ODBC äðàéâåð (îò ñàéòà íà mysql.com, ïî-ñêîðî ìàé îò dev.mysql.com), è äà íàïðàâèø ODBC data source (ïðè ìåí å â Start - Administrative Tools - Data Sources (ODBC), ïðè òåá àêî å WinXP ìàé äðóãàäå áåøå), êîéòî îáâúðçâàø ñ äàäåíà äåéòàáàçà, è íÿêîè îïöèè.
    Òîâà å ïðîñòî âàðèàíò, ïîëçâàéêè mysql, íî àêî ñè íàìåðèë 3rd party ïðîãðàìè, êîèòî ãî ïðàâÿò âìåñòî management studio-òî, Îê, ñòèãà äà ðàáîòÿò êàêòî òðÿáâà. Çàâèñè è çà êàêâî òè òðÿáâà òîçè åêñïîðò, àêî å çà áåêúï, ñè èìà îïöèè äèðåêòíî. Èëè çà êîïèðàíå â äðóãà ms sql áàçà/ñúðâúð.

  5. #5
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location: Âàðíà
    Posts: 260
    Çà ìèãðàöèÿ êúì MySql server.

    Òàêà,÷å âàðèàíòà çà êîéòî ãîâîðèø àêî ñòàíå ùå å ïåðôåêòåí.

  6. #6
    philosophus duratea icaci's Avatar
    Join Date: Oct:2006
    Location: Aachen
    Posts: 2,698
    Quote Originally Posted by bombov View Post
    ×ðåç îïöèÿòà èì Generate Scripts ñå ïîëó÷àâà íåùî ïîäîáíî,íî sql êîäà êîéòî ñå ãåíåðèðà å ñàìî ñ òàáëèöèòå,à íå ñúñ ñàìèòå çàïèñèòå çàïèñè, êîèòî ñà âàæíèòå â ñëó÷àÿ.
    Êàòî ñòèãíåø äî äèàëîãà ñ îïöèèòå íà Generate Scripts, â ñåêöèÿòà "Table/View Options" ñëàãàø Script Data íà True è ñëàãàø îòìåòêè íà âñè÷êè òàáëèöè â ñïèñúêà, êîéòî èçëèçà 2-3 ñòúïêè ïî-íàòàòúê. Ïî ïîäðàçáèðàíå Script Data å False è çàòîâà ïîëó÷àâàø SQL áåç INSERT-îâå.
    Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others

  7. #7
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Quote Originally Posted by icaci View Post
    Êàòî ñòèãíåø äî äèàëîãà ñ îïöèèòå íà Generate Scripts, â ñåêöèÿòà "Table/View Options" ñëàãàø Script Data íà True è ñëàãàø îòìåòêè íà âñè÷êè òàáëèöè â ñïèñúêà, êîéòî èçëèçà 2-3 ñòúïêè ïî-íàòàòúê. Ïî ïîäðàçáèðàíå Script Data å False è çàòîâà ïîëó÷àâàø SQL áåç INSERT-îâå.
    Ïðè ìåí òàì ëèïñâà Script Data. Êàêòî è ïîä äðóãèòå ñåêöèè íàãîðå.
    SQL 2005 x64.

  8. #8
    Registered User
    Join Date: Sep:2003
    Location: Where you live
    Posts: 976
    mysqldump --host=127.0.0.1 --add-drop-table --allow-keywords --all-databases -u{potrebitel} -p{parolata} > all.sql

    òîâà òè å ñêðèïòà çà äúìï íà âñè÷êè òàáëèöè.


    Ñåãà ïðî÷åòîõ íàíîâî è âèäÿõ ÷å èñêàø äà äúìïâàø mssql áàçà. òîâà å çà äúìï íà mysql. òàêà ÷å òîçè ïîñò íå ñå áðîè.
    Last edited by dzk; 10th August 2010 at 12:53.

  9. #9
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location: Âàðíà
    Posts: 260
    Quote Originally Posted by icaci View Post
    Êàòî ñòèãíåø äî äèàëîãà ñ îïöèèòå íà Generate Scripts, â ñåêöèÿòà "Table/View Options" ñëàãàø Script Data íà True è ñëàãàø îòìåòêè íà âñè÷êè òàáëèöè â ñïèñúêà, êîéòî èçëèçà 2-3 ñòúïêè ïî-íàòàòúê. Ïî ïîäðàçáèðàíå Script Data å False è çàòîâà ïîëó÷àâàø SQL áåç INSERT-îâå.
    Íà 2005 íÿìà òàêâà îïöèÿ.

    Click image for larger version. 

Name:	Options.JPG 
Views:	47 
Size:	102.1 KB 
ID:	31868

    Quote Originally Posted by tedych View Post
    Êúì çà êàêâîòî èìàø ODBC äðàéâåð.
    Çà äà âèäèø mysql ODBC íåùî òàì, òðÿáâà ïúðâî äà èíñòàëèðàø mysql ODBC äðàéâåð (îò ñàéòà íà mysql.com, ïî-ñêîðî ìàé îò dev.mysql.com), è äà íàïðàâèø ODBC data source (ïðè ìåí å â Start - Administrative Tools - Data Sources (ODBC), ïðè òåá àêî å WinXP ìàé äðóãàäå áåøå), êîéòî îáâúðçâàø ñ äàäåíà äåéòàáàçà, è íÿêîè îïöèè.
    Òîâà å ïðîñòî âàðèàíò, ïîëçâàéêè mysql, íî àêî ñè íàìåðèë 3rd party ïðîãðàìè, êîèòî ãî ïðàâÿò âìåñòî management studio-òî, Îê, ñòèãà äà ðàáîòÿò êàêòî òðÿáâà. Çàâèñè è çà êàêâî òè òðÿáâà òîçè åêñïîðò, àêî å çà áåêúï, ñè èìà îïöèè äèðåêòíî. Èëè çà êîïèðàíå â äðóãà ms sql áàçà/ñúðâúð.
    Click image for larger version. 

Name:	Setting ODBC.JPG 
Views:	57 
Size:	71.0 KB 
ID:	31870

    Íàïðàâèõ êîíåêöèÿ,íî íå ñå ïîêàçâà â My ODBC connection â MS SQL Server 2005.Îùå êàêâè îïöèè òðÿáâà äà ñå íàïðàâÿò,÷å òúðñÿ,íî íåùî íå ìîãà äà ãè íàìåðÿ.
    Last edited by bombov; 10th August 2010 at 20:10.

  10. #10
    Registered User dip's Avatar
    Join Date: Dec:2009
    Location: BG
    Posts: 55
    Ïðåç .sql ôàéë íÿìà äà ñòàíå.
    Òðÿáâà äà íàïðàâèø ìèãðàöèÿ íà áàçàòà,
    ïðî÷åòè òóê:
    http://dev.mysql.com/tech-resources/...microsoft.html
    Core i7 920 Rev. D0 - Cooled by Corsair Hydro H50/ASUS P6T/Corsair XMS3 6GB DDR3 kit 3x2GB/ASUS ENGTX275/ASUS Xonar DS/Corsair F120 SSD + WD Caviar Black 32MB 2x500GB/Corsair HX 1000W/Lian Li B25B Case/Samsung SyncMaster 2233RZ 120Hz/3D Vision/Logitech UltraX Premium Keyboard/Logitech G9 Mouse

  11. #11
    philosophus duratea icaci's Avatar
    Join Date: Oct:2006
    Location: Aachen
    Posts: 2,698
    Ìîÿ ãðåøêà - SQL Server-úò ìè å 2008.
    Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others

  12. #12
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Åìè çíà÷è ñà ñå óñåòèëè, ÷å çà íÿêîè õîðà åêñïîðò äî SQL íà äàííèòå èì å íåîáõîäèì ïî íÿêàêâà ïðè÷èíà. Íà ìåí ÷åñòíî êàçàíî äîñåãà íå ìè ñå å íàëàãàëî òî÷íî äî .sql, âñúùíîñò 1-2 ïúòè, íî ñå íàìåðè äàæå ïî-åëåãàíòíî ðåøåíèå òîãàâà. Íàëàãàëî ìè ñå å äà èìïîðòâàì .sql (ãîëÿì, íÿêîëêîñòîòèí ÌÁ), è äîáðå ÷å íàìåðèõ è .CSV âåðñèÿ íà äàííèòå, êîÿòî ñå èìïîðòâà áåç ïðîáëåì â SQL 2005, èíà÷å òðÿáâàøå äà èìïîðòâàì sql-à â mysql îòòàì äà âðúçâàì ñ MS è èçîáùî õàìàëîãèÿ.

    bombov, â ìîìåíòà ãî íÿìàì èíñòàëèðàí êîíåêòîðà (áëèçêèòå 1-2 ãîäèíè íå ìè ñå å íàëàãàëî mysql ïðåç odbc, íî èìàì ñïîìåí, ÷å ñå ïîÿâÿâàøå íîðìàëíî odbc source-a. Ùå ïðîáâàì òèÿ äíè.

    Btw íîâèÿ Workbench 5.2.x çà mysql èçãëåæäà äîáðå, ïðåäè áåòàòà áåøå ñòðàøíî áúãàâà è ñè ïîëçâàì äîñåãà ñòàðèòå mysql administrator/query browser..

  13. #13
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location: Âàðíà
    Posts: 260
    Ùå ñúì áëàãîäàðåí àêî íÿêîé ìîæå äà ìè ïðåïîðú÷à ñîôòóåð çà åêñïîðòâàíå îò MS SQL Server êúì Mysql Server íà áàçà äàííè.

    Òîâà ïðåç ñúðâúðà ãî ìú÷à ,íî òàêà ODBC driver íå ñå ïîÿâàâà.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè