|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2158
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤E¤ë 08, 2004 10:50 am ¤å³¹¥DÃD: §Ú·Qn±NM$SQLªº¸ê®Æ®w±q¤@¥xserver²¾¦Ü¥t¤@¥xserver¡A¦³¤°»ò¤ñ¸û¦nªº¤èªk¶Ü¡H |
|
|
¸ê®Æ¨Ó·½: http://support.microsoft.com/default.aspx?scid=fh;ZH-TW;sfaq3075
¦pªG¤G¥xserverªºCode Page (Character Set & Sort Order)¬Û¦P¡A¥i¥H
±N¸ê®Æ®w±qServer 1³Æ¥÷¥X¡A¦A®³¦ÜServer 2°µrestore
±Ndata file (.mdf)¤Îlog file (.ldf) copy¦Üserver 2¡A¦A°õ¦æ sp_attach_db '<dbname>' , '<datafile name>' , '<logfile name>' ...
±N¸ê®Æ®wattach¦Ü¥t¤@¥xserver
¨Ò: exec sp_attach_db N'northwind', N'd:\mssql7\data\northwnd.mdf', N'd:\mssql7\data\northwnd.ldf'
go
Y¤G¥xserver¤§Code Page¤£¦P¡A«h¥i¨Ï¥ÎDTS(Data Transformation Services)±N¸ê®Æ®wtransfer¦Ü¥t¤@¥xserver¡C _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 10, 2004 5:36 pm ¤å³¹¥DÃD: |
|
|
¤Þ¨¥¦^ÂÐ: |
¦pªG¤G¥xserverªºCode Page (Character Set & Sort Order)¬Û¦P¡A¥i¥H
±N¸ê®Æ®w±qServer 1³Æ¥÷¥X¡A¦A®³¦ÜServer 2°µrestore
±Ndata file (.mdf)¤Îlog file (.ldf) copy¦Üserver 2¡A¦A°õ¦æ sp_attach_db '<dbname>' , '<datafile name>' , '<logfile name>' ...
±N¸ê®Æ®wattach¦Ü¥t¤@¥xserver
¨Ò: exec sp_attach_db N'northwind', N'd:\mssql7\data\northwnd.mdf', N'd:\mssql7\data\northwnd.ldf'
go
|
¥Ø«e§Ú¦³°µ³o¼Ëªº¥\¯à,
1. ¥H SQLSTRINGCONNET() ³s±µSQL A
2. ¥H SQLEXEC() ¤U DETACH DB
3. COPY FILE TO SQL B
4. ¥H SQLSTRINGCONNET() ³s±µSQL B
5. ¥H SQLEXEC() ¤U ATTACH DB _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2158
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 10, 2004 8:02 pm ¤å³¹¥DÃD: |
|
|
¥H«e³£¥ÎSQL SERVER©ÒªþªººÞ²z¤u¨ã¥h°µ SQL SERVER A°µBACKUP«á, ¦A¥hSQL SERVER B°µrestore , ²{¦b¬O¦w¸ËMSDE´N¨S¦³³o¨Ç¤u¨ã¥i¥H¥Î¤F , ¥»¨Ó¬O¥Îµ{¦¡¼grestore¥\¯à, ¦ý¦³®É·|¦³°ÝÃD, ³o´X¤Ñ¬ã¨s¥Î attach dbªº¤è¦¡¤ñ¸ûéw¤F, ¥H¤U¬O§Ú¼gªºµ{¦¡½X, ¦³»Ýnªº¤H°Ñ¦Ò¬Ý¬Ý§a!
¥N½X: |
*¥»µ{¦¡°²³]§A¤w¸g±NSQL DATABASEªº2ÓÀɮ׬Ҥw¦s³o©ñµ{¦¡ªº³oӥؿý¤W¤F.
msqlpath = [C:\Program Files\Microsoft SQL Server\MSSQL\Data\]
mdsn = [DRIVER=SQL Server;SERVER=]+ALLTRIM(left( sys(0), at('#',sys(0))-1 ))+[;DATABASE=master;Trusted_Connection=Yes]
mdatabase='trade' &&-- SQL DATABASEªº¦WºÙ
mmdf = mdatabase+[_data.mdf]
mldf = mdatabase+[_log.ldf]
wait windows 'copy DATABASE file......' nowait
copy file &mmdf to "&mmdf"
copy file &mldf to "&mldf"
wait clear
sqlhead=SQLSTRINGCONNECT( mdsn )
if sqlhead<=0
messagebox('can not connect to SQL SERVER ('+ left( sys(0), at('#',sys(0))-1 ) +')' )
return
endif
wait windows 'restore database.......Please wait ...' nowait
mret = SQLEXEC( sqlhead,[sp_attach_db ']+mdatabase+[', ']+msqlpath+mmdf+[',']+msqlpath+mldf+['])
wait clear
if mret>0
messagebox(' RESTORE OK ^^' )
else
messagebox(' can not RESTORE DATABASE ')
endif
=SQLDISCONNECT(sqlhead)
return
|
_________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤E¤ë 10, 2004 11:39 pm ¤å³¹¥DÃD: |
|
|
¦Ñ¹ê»¡,
§Ú¤]¬O¦]¬°«È¤á¤£·Qªá¿ú¶RM$ SQL SERVER »Ýn±N´N¥ÎMSDE ,
¤~°µ³o¼Ëªº¥\¯à..... _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤Q¤@¤ë 09, 2008 5:57 pm ¤å³¹¥DÃD: |
|
|
to garfield
¥N½X: | Local nHandle,sqlCommand,sqlText,lc_Path
lcDB_Name=Alltrim(ReadIniFile("Startup","Database",mgSys_Path+"main.ini"))
lcDB_Server=Alltrim(ReadIniFile("Startup","DBServer",mgSys_Path+"main.ini"))
lcDB_Uid=Alltrim(ReadIniFile("Startup","UID",mgSys_Path+"main.ini"))
lcDB_Pwd=Alltrim(ReadIniFile("Startup","PWD",mgSys_Path+"main.ini"))
Try
oserver=Createobject("sqldmo.sqlserver")
oserver.Connect(lcDB_Server,lcDB_Uid,lcDB_Pwd)&&³s±µ
obackup=Createobject("sqldmo.backup")
obackup.Database=lcDB_Name
obackup.Password="12345" &&µ¹³Æ¥÷ÀÉ®×�#91;±K½X
bakfile=mgSys_Path+"backup\sc_"+Dtos(Date())+".dat"
obackup.Files=bakfile
obackup.initialize=.T.
obackup.ACTION=0
obackup.SQLBackup(oserver)
Messagebox("¶×¥X¸ê®Æ§@·~§¹¦¨!! "+mgSys_Path+"backup\sc_"+Dtos(Date())+".dat",0+64,"´£¥Üµøµ¡")
Catch To Foobar
Messagebox("²§±`¿ù»~¡I¡I¥i¯à¬O±b¸¹©Î±K½X",0+64,"´£¥Üµøµ¡")
Finally
*CLEAR EVENTS
Endtry |
¥N½X: | LOCAL nHandle,sqlCommand,sqlText
lcDB_Name=Alltrim(ReadIniFile("Startup","Database",mgSys_Path+"main.ini"))
lcDB_Server=Alltrim(ReadIniFile("Startup","DBServer",mgSys_Path+"main.ini"))
lcDB_Uid=Alltrim(ReadIniFile("Startup","UID",mgSys_Path+"main.ini"))
lcDB_Pwd=Alltrim(ReadIniFile("Startup","PWD",mgSys_Path+"main.ini"))
gcTable=GETFILE('DAT', '½Ð¿ï¾ÜÁÙ쪺ÀɮסG','ÂsÄý', 0, 'ÂsÄýÀÉ®×')
IF LEN(ALLTRIM(gcTable))==0
MESSAGEBOX("¥¼¿ï¨úÀɮסI¡I",0+64,"´£¥Üµøµ¡")
RETURN
ENDIF
oserver=CREATEOBJECT("sqldmo.sqlserver")&&«ØSERVER¹ï¶H
oserver.Connect(lcDB_Server,lcDB_Uid,lcDB_Pwd)&&³s±µ
orestore=CREATEOBJECT("sqldmo.restore")
orestore.Database=lcDB_Name
orestore.Files=allt(gcTable)
orestore.Password="12345"
orestore.SQLRestore(oserver)
MESSAGEBOX("¶×¤J¸ê®Æ§@·~§¹¦¨!!",0+64,"´£¥Üµøµ¡") |
_________________ ºÖ¶©©÷²b¤ô¦³¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!
·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.
¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤¤ë 28, 2016 11:27 am ¤å³¹¥DÃD: |
|
|
garfield ¼g¨ì: | ¥H«e³£¥ÎSQL SERVER©ÒªþªººÞ²z¤u¨ã¥h°µ SQL SERVER A°µBACKUP«á, ¦A¥hSQL SERVER B°µrestore , ²{¦b¬O¦w¸ËMSDE´N¨S¦³³o¨Ç¤u¨ã¥i¥H¥Î¤F , ¥»¨Ó¬O¥Îµ{¦¡¼grestore¥\¯à, ¦ý¦³®É·|¦³°ÝÃD, ³o´X¤Ñ¬ã¨s¥Î attach dbªº¤è¦¡¤ñ¸ûéw¤F, ¥H¤U¬O§Ú¼gªºµ{¦¡½X, ¦³»Ýnªº¤H°Ñ¦Ò¬Ý¬Ý§a! |
¥Îµ{¦¡sqldmo.backup ¼gªº½T¹ê¦³°ÝÃD!!!
¥Ø«e¥¿¦b§ä·s¤èªk _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤¤ë 28, 2016 11:31 am ¤å³¹¥DÃD: |
|
|
garfield ¼g¨ì: | ¥H«e³£¥ÎSQL SERVER©ÒªþªººÞ²z¤u¨ã¥h°µ SQL SERVER A°µBACKUP«á, ¦A¥hSQL SERVER B°µrestore , ²{¦b¬O¦w¸ËMSDE´N¨S¦³³o¨Ç¤u¨ã¥i¥H¥Î¤F , ¥»¨Ó¬O¥Îµ{¦¡¼grestore¥\¯à, ¦ý¦³®É·|¦³°ÝÃD, ³o´X¤Ñ¬ã¨s¥Î attach dbªº¤è¦¡¤ñ¸ûéw¤F, ¥H¤U¬O§Ú¼gªºµ{¦¡½X, ¦³»Ýnªº¤H°Ñ¦Ò¬Ý¬Ý§a!
¥N½X: |
*¥»µ{¦¡°²³]§A¤w¸g±NSQL DATABASEªº2ÓÀɮ׬Ҥw¦s³o©ñµ{¦¡ªº³oӥؿý¤W¤F.
msqlpath = [C:\Program Files\Microsoft SQL Server\MSSQL\Data\]
mdsn = [DRIVER=SQL Server;SERVER=]+ALLTRIM(left( sys(0), at('#',sys(0))-1 ))+[;DATABASE=master;Trusted_Connection=Yes]
mdatabase='trade' &&-- SQL DATABASEªº¦WºÙ
mmdf = mdatabase+[_data.mdf]
mldf = mdatabase+[_log.ldf]
wait windows 'copy DATABASE file......' nowait
copy file &mmdf to "&mmdf"
copy file &mldf to "&mldf"
wait clear
sqlhead=SQLSTRINGCONNECT( mdsn )
if sqlhead<=0
messagebox('can not connect to SQL SERVER ('+ left( sys(0), at('#',sys(0))-1 ) +')' )
return
endif
wait windows 'restore database.......Please wait ...' nowait
mret = SQLEXEC( sqlhead,[sp_attach_db ']+mdatabase+[', ']+msqlpath+mmdf+[',']+msqlpath+mldf+['])
wait clear
if mret>0
messagebox(' RESTORE OK ^^' )
else
messagebox(' can not RESTORE DATABASE ')
endif
=SQLDISCONNECT(sqlhead)
return
|
|
³oÓ¤èªk¬O
Åýsqlserver°±¥Î
¤~¥h³Æ¥÷ªº¶Ü??? _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤¤ë 28, 2016 11:22 pm ¤å³¹¥DÃD: |
|
|
¥Î DETACH/ATTACH DB ¨Ó·h¸ê®Æ®w,
SQL SERVER ¨Ã¨S¦³°±¥Î.
¥u¬O¼È®É§â¬Y¤@Ó¸ê®Æ®w²¾°£¦Ó¤w.
¦pªG§âSQL SERVER °±¥Î¦ACOPY ÀÉ®×,
SQL SERVER 2000 ®É§Ú¥Î¹L,
³o¼Ë¤]¥i¥H.
(§Ú¹J¨ìªºCASE «Ü½ÆÂø,¦]¬°«È¤áªºSQL SERVER µwÅé(µwºÐ)·lÃa,ªá¤F¤@µf¥\¤Ò¤~·d¦¨¤ñ¸û¥¿±`ªº±¡ªp)
¤£¹L SQL SERVER 2008 ¥H«á,
¼W¥[«Ü¦h©ÇÅv³]©w,
³s¥Î DETACH/ATTACH DB ¨Ó·h¸ê®Æ®w,
³£«Ü³Â·Ð.
¥t¥~¤@®a¨ó¤OµwÅé°Ó«Ü·RÀ°¥Lªº«È¤á¤É¯ÅSQL SERVER,
¨C¦¸³£Ä±±oM$¤£n¦A¾ã§Ú¤F. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤¤ë 28, 2016 11:27 pm ¤å³¹¥DÃD: |
|
|
garfield ¼g¨ì: | ¥H«e³£¥ÎSQL SERVER©ÒªþªººÞ²z¤u¨ã¥h°µ SQL SERVER A°µBACKUP«á, ¦A¥hSQL SERVER B°µrestore , ²{¦b¬O¦w¸ËMSDE´N¨S¦³³o¨Ç¤u¨ã¥i¥H¥Î¤F |
±q SQL SERVER 2008 ¶}©l,
M$´£¨Ñ SQL Server Management Studio Express ,
¥i¥HºÞ²z¸ê®Æ®w,
¦ý¬O M$ ÁÙ¬O M$,
¦¤@ÂIªº,¨S¦³ SQL PROFILER ¤u¨ã,
SQL 2012 EXPRESS ª©ªº ¤£¥i¥H½Õ¾ãTABLE µ²ºc,
¤U¸ü¨Ï¥Î®É½Ð°µ¦n¤ß²z·Ç³Æ. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤¤ë 30, 2016 2:33 pm ¤å³¹¥DÃD: |
|
|
«ç»ò¤£¥Î³oÓ¤èªk??!
¥N½X: |
D:\osql -E < u_Backup.sql
|
u_Backup.sql ¤º®e
¥N½X: |
USE ezpos
GO
BACKUP DATABASE ezpos
TO DISK = 'D:\ezpos.bak'
WITH FORMAT,
NAME = 'Full Backup of EZPOS'
GO
|
§Ú¥Î³oÓ¤èªk°µ±Æµ{..¨S¿ìªk°µ¨ì³Æ¥÷?¤â°Ê«ö¥i¥H.
¥i¯à¥X¦bÅv? _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|