SQL Server Compact 3.5 SP2ÒѾ·¢²¼
Ëæ×ÅVisual Studio 2010µÄ·¢²¼£¬Microsoft SQL Server Compact 3.5Ò²Éý¼¶ÎªMicrosoft
SQL Server Compact SP2¡£
ÏÂÔصØÖ·ÈçÏ£º
SQL
Server Compact 3.5 SP2 for Windows mobile devices (all platforms &
processors)
SQL
Server Compact 3.5 SP2 for Windows desktop (32-bit and 64-bit)
SQL
Server Compact 3.5 SP2 Server Tools (32-bit and 64-bit)
SQL Server Compact
3.5 SP2 Books Online
(¸ÃÁ´½ÓÔÚÏÂÖܲŻáÉúЧ)
SQL Server Compact 3.5 SP2
Samples
Refer to: http://www.wpmind.com/dev/2010/04/15/sql-ce-3-5-sp2-is-released.html
Ïà¹ØÎĵµ£º
Ò»﹕
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì﹐Ëü²»Äܱ»ÏÔʽµØµ÷ÓÃ﹐¶øÊÇÔÚÍù±íÖвåÈë¼Ç¼﹑¸üмǼ»òÕßɾ³ý¼Ç¼ʱ±»×Ô¶¯µØ¼¤»î¡£ËùÒÔ´¥·¢Æ÷¿ÉÒÔÓÃÀ´ÊµÏÖ¶Ô±íʵʩ¸´ÔÓµÄÍê
ÕûÐÔÔ¼`Êø¡£
¶þ﹕ SQL
ServerΪÿ¸ö´¥·¢Æ÷¶¼´´½¨ÁËÁ½¸öרÓñí ......
¡¡¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡ mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> ......
-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ì滻ΪÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......
1. °²×°oracle 10G¿Í»§¶Ë
Òª·ÃÎÊoracleÊý¾Ý¿â±ØÐë°²×°oracle¿Í»§¶Ë¡£°²×°oracle¿Í»§¶ËÓÐÁ½ÖÖ·½Ê½£¬¼´ÍêÕû°²×°ºÍÁ¢¼´°²×°£¬ÕâÁ½ÖÖ·½Ê½¶¼¿ÉÒÔ¡£°²×°ÍêºóÅäÖÃÒªÁ´½ÓÊý¾Ý¿â·þÎñÆ÷¡£
$ORACLE_HOME\network\admin\tnsname.ora
ÔÚ´ËÅäÖÃÎļþÀïÌí¼ÓÈçÏÂÄÚÈÝ£º
sunora =
(DESCRIPTION =
......