????? ??? SQL Server 2005 ??? Edition

???? ???????: 920700 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
?????? ?? SQL Server 2005 ??? Edition ????? SQL Server 2005 ?? ???? Edition ????? ????? ????? ??????. ???? ?????? ?? ??? ????? ?? ?????? ????? ??????? (CTP) ??? ???? ??????? ?????? ??????? ???? ???????? ??? Microsoft ?? ??? ?????? ??? ?? ???? ??????? ?? ????? ???????? ?????? ????? ???????? ?? ???????. Microsoft ???????? ??? ????????? ????? ??? ?? ????? ??? ?????? ?????? ????? ????.
????? ???? | ?? ????

?? ??? ??????

????? ???

????? Microsoft SQL Server 2005 ??? Edition (SQL Server ??? Edition) rebranding Microsoft SQL Server 2005 ??????? Edition (SQL Server ??????? 3.0) ??? ????? ??? ??????. ?? ????? SQL Server ??????? 3.0 ?? 2005 ???????? Microsoft Visual Studio 2005 ?? ?? SQL Server 2005. ?????? ???? SQL 3.0 ????? ??? ????? ?? ??? ?????? ????? ?????????. SQL Server ??????? 3.0 ?????? ????? ??? ????? ??????? ??? ??????.

???????? SQL Server ??????? 3.0 ??? ????? ??????? ??? ?????? ??? ????? Visual Studio 2005 ?? SQL Server 2005. ??? ???? ?? SQL Server ??? Edition, ??? ??????? ?? ?????. ?? SQL Server ??? Edition? ????? ????? ???? ??????? ????? ?? SQL Server 2005 ?? Visual Studio 2005.

?? ?????? ?? SQL Server ??? Edition ??????? ????? ?????? (CTP) ?? ?? ????? ????. ?? ????? SQL Server ??? Edition ??????? ?????? 1 (RC1) ?? 7 ?????? ????. ?? ?? ??????? CTP ? ????? RC1 ?? SQL Server Edition ??? ?? ??? ?? ??? ????????? ??? ???????. ?? ????? ??????? ??? ????? (RTW ???) ?? SQL Server Edition ??? ??????? ????? ????? ??? 15 ????? ????. ??? ????? SQL Server ??? RTW ??????? 3.1. ?? ??????? ??? ??????? ?? ????? SQL Server Edition ??? RTW:
  • ??? ??????? ?? Microsoft SQL Server 2005 Edition ???
  • ????? Edition ??? Microsoft SQL Server 2005 ?? Visual Studio 2005 Service Pack 1 (SP1)
  • ????? ????? ????? ?????? Edition ??? "Server 2005 Microsoft SQL" (SDK)
  • ????? Server Edition ????? ?? Microsoft SQL Server 2005
  • Microsoft SQL Server 2005 Edition ??? ????? ??? ??????
?? ????? SQL Server Edition ??? ??????? ????? ????? ?? ?????? ???????:
  • ?????????
  • ??????????
  • ?????????
  • ????????
  • ?????????
  • ?????????
  • ???????
  • ??????? ?????????
  • ??????? ???????
  • ???????
???? ????? SQL Server Edition ??? ??????? ?? SQL Server ?? ???????? ?????? ???? ????. ???? ????? SQL Server 2005 ?????? ????? ?????? SP2 (SP2) ?? ????? ????? 2007. ???? ??? ????? ????? ??????? ?? ??? ???? ???? Microsoft SQL Server Edition ???:
  • SQL Server Edition ??? ????? ??? ????? ?? ???? ????? ?????? ???????.
  • ?? ?????? SQL Server Edition ??? ??? Microsoft Update ?? ????? ????? 2007.
  • ???? ????? SQL Server Edition ??? ???? ?? ????? SQL Server 2005 ?????? ????? ?????? SP2.
???? ??? ?????? | ????? ???????

??????? ????

SQL Server ??? Edition Runtime (SQLServerCE31 EN.msi)

????? SQL Server Edition ??? ?? ??? ??????? ???? ???? ????????? ?????? ??????? ??? ???? ????????? ??? ????? ??????? ??? ?????? ???? ?????? ????? ?????????. SQL Server Edition ??? ???? ????? ?????? ??????? ?????? ??? ?????. ???? SQL Server Edition ??? ?????? ???? ???? SQL. ???????? ??? ???? ???? SQL Server Edition ??? ???? ????? ? API ???? ?????? ?? SQL Server. ????? ????? ???? ???? ????? ????? ??????? ??? ?????? ???????? ????? SQL Server Edition ??? ?? RTW ???????? SQL Server ???????. ????? SQL Server Edition ??? ????? ????? ??? ????? ????????? |DataDirectory| ??? ???? ClickOnce ???? ???? ?????.

?????? Runtime ????? SQL Server ??? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/downloads/details.aspx?familyid=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3
(http://www.microsoft.com/downloads/details.aspx?familyid=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3)
????? ????? SQL Server ??? Edition Runtime DLLs ???????:
  • Sqlceca30.dll
  • Sqlcecompact30.dll
  • Sqlceer30en.dll
  • Sqlceme30.dll
  • Sqlceoledb30.dll
  • Sqlceqp30.dll
  • Sqlcese30.dll
  • System.Data.SqlServerCe.dll
????? ???? Microsoft Windows Installer ?? "??? SQL Server ??? Edition ???????" (SQLServerCE31 EN.msi) ??? ?????. ??? ????? ???? Windows Installer ?????? ?? ???? ???? ??????? serviceability ?????????? ?? SQL Server Edition ???. ??? ????? SQL Server Edition ??? ??? ????? ?????? (System.Data.SqlServerCe.dll) ?? ????? ??????? ??????? ??????? ??????? (GAC). ???????? ??? ???? ??? ????? ???? OLE DB (Sqlceoledb30.dll).

?????? ???? OLE DB ??? ?? ???? ???? ?????? ???????. ????? ?? ????? ????? SQL Server Edition ??? ??? ??? ??? ???? ?????? ???????. ????? ???? Windows Installer ??? ????????? ?? ?????? "Edition\v3.1 SQL Server ??? ??? %ProgramFiles%\Microsoft". ??? ????? SQL Server Edition ??? ????? ????? Microsoft SQL Server 2005 ??? Edition ?? ????? ?? ????? ???????.

?????? ????? ????? (.msi SQLServerCE31-[LN]) ? ??? ????? ??????? ????????? (SQLServerCE31 EN.msi) ?????? ?? ????? ????? ?????.
?????????? [LN] ??? ??????.

????? SQL Server ??? ??????? ?? Visual Studio 2005 ?????? ????? ?????? SP1 (SSCE31VSTools-ENU.exe)

????? SQL Server ??? ??????? ?? Visual Studio 2005 ?????? ????? ?????? SP1 ?????? ?????? ??????? ?????? ?????? Microsoft Visual Studio 2005 ?????? ????? ?????? SP1 ???????? ???? ??? ??????? SQL Server Edition ???.

?????? ????? Edition ??? ?? SQL Server ?? Visual Studio 2005 ?????? ????? ?????? SP1 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/downloads/details.aspx?FamilyId=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyId=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en)
?????? ????? ????? (SSCE31VSTools-[LN] .exe) ? ??? ????? ??????? ????????? (SSCE31VSTools-ENU.exe) ?????? ?? ????? ????? ?????.

SQL Server ??? Edition ?????? SDK (SSCE31SDK ENU.msi)

????? SQL Server ??? Edition ?????? SDK ??????? ??????? ?????? ????????? ???????? SQL Server Edition ??? ???? ????? ?????? ?????????:
  • ??????? & .cab & ?????? SQL Server Edition ??? ??? ??????? ????????
  • ??? .msi ?????? SQL Server Edition ??? ??? ????? ??????? ??? ?????? ???? "????? ????????? ???????"
  • ??????? ??? ??????? ?????? ????? SQL Server Edition ??? ??????
  • ??? .msi ?????? ????? SQL Server ??? Edition ???????
?????? SQL Server ??? Edition ?????? SDK ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en)
????? ????? ????? ?????????? ?? SQL Server ??? Edition ?????? SDK ??? ????? ????? ?????????? ??? ?? SQL Server ??? Edition Runtime. ????? ????? ????? ?? SQL Server ??? Edition ?????? SDK ??? ????? ????? ?????????? ?? SQL Server ??? Edition Runtime ????? ?????? SQL Server ??? Edition Runtime. ??? ????? SQL Server ??? Edition SDK ?????? ??????? ???? ???? SQL Server ??? Edition Runtime ?? ?????? ??????:
Edition\v3.1\SDK\bin\Desktop %programfiles%\Microsoft SQL Server ???
?????? ????? ????? ?? SQL Server ??? Edition Runtime ?? ????? ????? ?? SQL Server 2005 ??? Edition ?????? SDK ???? ??????? ???????:
  1. ???? ?????? ??????:
    Edition\v3.1\SDK\bin\Desktop %programfiles%\Microsoft SQL Server ???
  2. ?? ?????? ????? ????? ?????????? ?? SQL Server ??? Edition Runtime (SQLServerCE31 EN.msi).
  3. ????? ????? ????? ?? SQL Server ??? Edition Runtime (.msi SQLServerCE31-[LN]).

????? SQL Server ??? Edition Server (Sqlce30setupen.msi)

????? ????? SQL Server ??? Edition Server ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/downloads/details.aspx?FamilyId=4E45F676-E69A-4F7F-A016-C1585ACF4310&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyId=4E45F676-E69A-4F7F-A016-C1585ACF4310&displaylang=en)
?????? ?????? ????? ????? (Sqlce30setup .msi [LN]) ? ?? ???? ????? ????? ????? ?????????? (Sqlce30setupen.msi) ?????.

SQL Server ??? Edition ????? Online (SSCE31BOL-EN.msi)

????? SQL Server ??? Edition ???????? ????? SQL Server Edition ???.

?????? "??? SQL Server ??? Edition ???????" ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en)
?????? ?????? ????? ????? (.msi SSCE31BOL-[LN]) ???? ?? ???? ????? ????? ????? ?????????? (SSCE31BOL EN.msi) ?????.

??????? ????? ??? ??? ?? Visual Studio 2005 ?? SQL Server 2005

????? ???? SQL ??????? 3.0 Visual Studio 2005 ?? SQL Server 2005 ????? ??? ???? ?????????. ??? ???? ?? ????? SQL Server Edition ??? ??? ??????. ????? ?????????? ????? ???? ????????? SQL Server Edition ??? ??? ?????? SQL Server 2005 ?? ????? Visual Studio 2005. ??? ???? ?? ???? ??? ??????? ??? ????????? ?????? ??? ???? ??????? ????? ??? SQL Server ??? Edition ????? ?? Visual Studio 2005 ?? ?? SQL Server 2005. ????? ?????????? ?????? ?????? ?? ????? ????? ??? ??? ?? Visual Studio 2005 ?? ?? SQL Server 2005.

???? Visual Studio 2005

Visual Studio 2005 ?? SQL Server Edition ???
  • ????? ?????? ?????? ?? Visual Studio 2005 ??? ??????? ??? ????? 3.0 ??????? ???? SQL.
  • ??? Visual Studio 2005 ???????? Runtime ????? SQL Server ???. ???? ??? ?????? ???? ????? SQL Server Edition ??? ?????? ?? GAC. ??? ??????? 3.0 ??????? ???? SQL ????? ?? ???? ??????? Visual Studio 2005. ??? ???? GAC ???????? ??? ??????? 3.0 ??????? ???? SQL. ????? ?????? Visual Studio 2005 ?????? Runtime ????? SQL Server ??? ??? ??? ???????.
Visual Studio 2005 ?????? ????? ?????? SP1 ?? SQL Server Edition ???
  • ???? ????? ?????? ??????? ???????? ?? SQL Server Edition ???.
  • ??? Visual Studio 2005 ?????? ????? ?????? SP1 ???????? Runtime ????? SQL Server ???.

???? SQL Server 2005

SQL Server 2005 ?? SQL Server 2005 ?????? ????? ?????? SP1 ?? SQL Server Edition ???
  • ??? ?????? ???????? ???? ??????? ??? ????? 3.0 ??????? ???? SQL.
  • ??? SQL Server 2005 ???????? Runtime ????? SQL Server ???.
SQL Server 2005 ?????? ????? ?????? SP2 ?? SQL Server Edition ???
  • ???? ????? ?????? SQL Server 2005 ?????? ????? ?????? SP2 ??????? ???????? ?? SQL Server Edition ???.
  • ??? SQL Server 2005 ?????? ????? ?????? SP2 ???????? Runtime ????? SQL Server ???.

??????? ???????

????? SQL Server Edition ??? ??? ????? ??? ????? ?? SQL Server ??????? 3.0. ????? ??? ??????? ?? ???:
  • ??? ????? ????????? |DataDirectory|
  • ??? ClickOnce

??? ????? ????????? |DataDirectory|

|DataDirectory| (????? ?? ???? ????? ???????) ?? ????? ??????? ???? ???? ??? ???? ????? ????????. ?????? ?? ???? ????? ?????? ?????? ?? ????????? ????????. ??? ????? ?????? ?????? ?? ????????? ???????? ?? ????? ?????? ???? ???? ???? ????? ????? ?????? ?????? ?????? ???????? ?? ????? ??????. ????? ??????? |DataDirectory| ????? ???? ?? ????? ??????? ????? ?? ???? ????? ??.

??? ???? ??????? ??? ??? ?????? ?????? ?????? ?? ????????? ???????? ???? ?? ????? ??????? ??? ????? ??????? ???????. 
Data Source= c:\program files\MyApp\Mydb.sdf
??? ??? ?????? ????? ????????? |DataDirectory| ?? ??????? ????? ??????? ???????. 
Data Source = |DataDirectory|\Mydb.sdf
?????? ??????? DataDirectory ??????? ??????? AppDomain.SetData. ?? ??? ?????? ??????? DataDirectory ??? ????? ??????? ?????????? ??????? ??? ?????? ??? ???? ????? ????????:
  • ????????? ???? ??? ??? ?? ???? ??? ???? ????????? ????? ????????? ???? ????? ???????? ?????? ???? ???????.
  • ????????? ???? ???? ??? ClickOnce ???? ????? ???????? ?????? ???? ???? ???????? ???? ?? ??????.
?????? ?? ????? .NET Framework ??? ????? AppDomain.SetData ??? ??????? ???????? ??? Microsoft Windows ???????. ??? ??? ??? ??????? ???????? ????? AppDomain.SetData ??? ???? ????? ??? Windows ??????? ? ????? ????? ???.

??? ClickOnce

ClickOnce ?? ????? ????? ????? ????? ???? SQL Server Edition ???. ???? ClickOnce ??? ??? ????????? ???????? ??? Windows ??? ???? ??? ?? ??? ??? ???? ?????. ???? ????????? ??? ?? ????? ??? ??????? ?????? ????? ??????? ??? ????. ?? ???? ????????? ????? ?? ???? ???? ????.

???? Visual Studio ????? ?????? ??? ????????? ???? ??? ????? ???????? ClickOnce ??????. ????? ????? ClickOnce ??????? ???????? ???? ?? ??????? ???????? Microsoft Visual Basic Microsoft Visual C# ? Microsoft Visual J#. ??? ???? ClickOnce ?? ????? ??? ??????? ???????? ???? ?? ??????? ???????? Microsoft Visual C++.

???? ????? ????? Edition ??? ?? SQL Server ?? Visual Studio 2005 ?????? ????? ?????? SP1 ??????? ??? Visual Studio 2005 ?????? ????? ?????? SP1. ????? ??? ?????? ClickOnce ?? ???? ?????? ??????? ClickOnce ???????? ?? ?????? ???????.
????? ????? ClickOnce ?? SQL Server Edition ???
?????? ??? ??????? ????????? ?? ??? ????? ??????? ????? ????? ?????????? ?? SQL Server Edition ???. ??? ??? ?????? ????? ??? ??? ?? SQL Server Edition ??? ?? ????? ????? ??????? ?? ????? ??????? ?? ?? ????? ????????. ??? ???? ??????? ?? ???? "??? ????????? ???????" "Zh" ????? ?? "EN".

??????? ClickOnce ?? SQL Server Edition ??? ? ????? ????? Edition ??? ?? SQL Server ?? Visual Studio 2005 ?????? ????? ?????? SP1 ??????? ??? Visual Studio 2005 ?????? ????? ?????? SP1. ??? ????? ??? ?????? ClickOnce. ??? ????? ????? ??????? ClickOnce ???????? ?? ?????? ???????. ??? ?????? ?????? ????? ClickOnce.
?? ??? ??????????? ??? ??????
??? ????????
Product.xml????? ?????? ???????
Package.xml????? ?? ??????? ???? ??????? ?? ?????? ??????? ??????? ??????? ??? ?????? ???????
EN.txt SqlCE31eula????? ??? ???? ????? ????? Microsoft
??? ?????? ?????? ????? ??????? ??????? ClickOnce.
?? ??? ??????????? ??? ??????
??? ??????????? ???? ??? ????? ?????
Product.xml% ???????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL Server ??? Edition\
Package.xml% ???????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL Server ??? Edition\en\
EN.txt SqlCE31eula% ???????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL Server ??? Edition\en\
EN.msi SQLServerCE31% ???????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL Server ??? Edition\en\
??? ??? ??????? ???? ????? ?????? ????? ClickOnce SQL Server Edition ??? ???? ClickOnce ?????? ??? EN.msi SQLServerCE31 ???? ???? ?????? ?? ?????? ??????. ?? ???? ??? ???? ???? ????? ClickOnce ?????? ????? EN.msi SQLServerCE31 ?? "???? ??????? ?? Microsoft" ????? ????? ???????.

??????? ????

?? SQL Server ??? ??????? 3. 1? ??? ????? ??? ????? ?????????? ?????? ??????? ?? ??? ????? ??????? ??? ?????? ?????? ??????. ??? ???? ????? ??? ????? ?????????? ??????? ??????? ???????? ?????? ????? ???????. ???? ?????? ?????? ????? ?????????? ?????? ?????? ?????????? ??????? ??? ?? ??????? ???????? ? ????? ??????? ??? ??????.
?? ??? ??????????? ??? ??????
????? ????????????? ?????????? ?????? ??????? ??????? ?????????????? ?????????? ??????? ??????? ??????? ?????????????? ?????????? ?????? ????? ??????? ??? ???????????? ?????????? ??????? ?? ????? ??????? ??? ??????
??? ?????? ?????? ??????640 ???? ????640 ???? ????640 ???? ????4096 ???? ????
???? ?????2000 ???? ?????2000 ???? ?????2000 ???? ?????5000 ???? ?????
??? ????? ????????128 ????????128 ????????128 ????????256 ????????
???????? ??? ????????? ?? ????? ?????????? ? ??? ????? ?????? ?? ????????? ?? ????? SQL Server Edition ???. ??? ????????? ??? ????? ???? SQL Server Edition ??? ??? ????? ??????? ??? ??????.

?????? ??? ????? ????? ????? ???????? ??? ?????? ??????? ?? SQL Server ??? ??????? 3.1 ????? ????? ??? ??? ??? ?????? ??????? ??????. ???? ??? ??????? ???? ?? ??? ????? ????? ????? ???? ????? ??????? ?? SQL Server ??? ??????? 3.1. ???? ????? ??? ??????? ?? ??????? ?????? ?? SQL Server Edition ???.

???????? ???????? ?? SQL Server ??? ??????? 3.1 ??? ???? ??????? Windows Vista

??? ?????? "??? ????? SQL Server ???" ??? ???? ??????? Windows Vista. ??? ?????? ????? ????? ???????? ?????? ??? ???? ??????? Windows Vista. ??? ???? ???? ??? ??????? ???????? ???????? ?? SQL Server ??? ??????? 3.1 ??? ???? ??????? Windows Vista. ??? ??????? ??????? ?????? ?????? ??????? ????????.

?????? ??? ??????? ?? ????????? ???????? ?????? ???? ????? ????? ?????? SQL Server 2005 ??? Edition ????????? ????? ??? SQL Server 2005 ??????? Edition. ??? ??????????? ????? ??? ?? ??????? ?????? ???? ? ?? ???? ????? ?????? ???? ??? ???? ???? Microsoft ????????. ???? ???????? ????? ???? ???????? ?? ????? ???????? ??? ???? ??????? "???? ????? ???????" ??? ???? ?.

??????? ??????

??? ??????? "????? ????? ??????? ???" ?????? ????? ??????? ???????? ?? Microsoft (IIS) 7.0 ??? ???? ??????? Windows Vista ???? ????? ????? ???????:
?? ??? ????? IIS
?? "????" ????? ????? ??????? ??? "????.

?????? ????? "????? ????? ??????? ???" ???? ?????? ?? IIS ?????? ??????? ??? SQL Server Edition ??? ? SQL Server.
???? ?????? ????? ??????? 1
??????? ?????? ??? ??? ??????? ???? ??????? ???????:
  1. ????? ???? ?????? IIS 6.0 ????? ??????? ??? ??????? "????? ????? ??????? ???".

    ?????? ????? ????? ??? ???????? ?? ??????? ???????? ?? "???? ??????".
  2. ??? ???? ???? ??????? ???? ?? ???????? "????? ?? ?? ??????" ????? ????? ??????? ??? "?? ???? ???????.

??????? 2

??? ????? ?????? ????? ????? SQL Server ??? Edition Server (Sqlce30setupen.msi) ??? "?????? ?????" ??? ??? ?????? ???????? "(LUA) ??? ???? ??????? Windows Vista ? ????? ????? ????? ???????:
?? ??? ?????? ??? ?????? ????? ???????? ???? SQL
???? ??? ??????? ??? ?? ???? ???? ?????? ????? ???????? SQL Server. ??? ????? ??? Sqlce30setupen.msi ???? ????? ???? ??? ??????? ???????? ??????. ??? ???? ??? ??? ????? ??? ??? ?? ???????, ?? ???? ????? ??? ???????.
???? ?????? ????? ??????? 2
??? ???? ???? ??????? ???? ?? ???????? "????? ?? ?? ?????? ????? Sqlce30setupen.msi.

??????? 3

??? ????? ?????? ????? ????? SQL Server ??? Edition Server (Sqlce30setupen.msi) ??? ??? ?????? ??? ???? ??????? Windows Vista ? ???? ???????.

???? ??? ??????? ??? ????? ??????? ???????? ????????? ??? ??????? ???????? ??????. ???? ??? ??????? ????? ??? ?? ????? ?????? ??????? ??????? ???????? ??????. ????? ?? ???? ?????? ?????? "???????" ??????? ????????? ???????? ???????? ??????.
???? ?????? ????? ??????? 3
????? ????? ???????? ????????? ???????? ??????????? ??? ????? ????? SQL Server ??? Edition Server.

??????? 4

???? ??? ????????? ??????. ???? ???? ??????? ???? ?????? Visual Studio 2005. ????? ???? ??????? ??? ??? ????????? ??? ???? ??????? Windows Vista. ?? ??? ?????????? ??? ??? ??????? SQL Server ??? ??????? 3.1 ?? Visual Studio 2005.

????? SQL Server ??? ??????? 3.1 ?? ????? SQL Server ??? ??????? ????? Visual Studio 2005 ?????? ????? ?????? SP1. ????? ??? ?????? ???????? ??????? SQL Server ??? ??????? 3.1 ?? Visual Studio 2005. ??? ?????? ????? ?????? ??? ??????? ??????? ???? ???????? Visual Studio 2005. ??? ????? ???? ??????? ??? ???? ??????? Windows Vista ??????? ??????.
???? ?????? ????? ??????? 4
??????? ?????? ??? ??? ??????? ???? ??????? ???????:
  1. ????? ????? ?????? "????? ?????? ??????" ?? Visual Studio 2005.
  2. ??? ??? ?????? ?????? ????? Edition ??? ?? SQL Server ?? Visual Studio 2005 ?????? ????? ?????? SP1 ????? ????? ????? Edition ??? ?? SQL Server Visual Studio 2005 ?????? ????? ?????? SP1.
  3. ????? ???? "????? ?????? ??????" ?? ????? ??????? ????? ?????? Visual Studio 2005.
  4. ????? ????? ????? SQL Server ??? ??????? ?? Visual Studio 2005 ?????? ????? ?????? SP1.

??????? 5

???? ??? ????????? ??????. ???? ??????? ???? ????? ??????? Windows Server 2008. ????? SQL Server 2005 ?????? ????? ?????? SP2 ??? ??? ?????????. ?? ???? ?????? ????? ????? ?????? ?? SQL Server ????? Studio ?????? ????? ?????? SQL Server Edition ??? ?????. ?? ??? ?????????? ????? ????? ????? ???????? ?? ?????? %WINDIR%\SYSTEM32.
???? ?????? ????? ??????? 5
????? ???? ?? ??? ????? ??? ????? ????? ?????? SQL Server Edition ??? ????? ?? SQL Server ????? Studio.

?????? ???? ?????? ?? SQL Server ??? ??????? 3.1

??????? ??????

???? ??? ????????? ??????. ??? ????? SQL Server ??? ??????? 3.1 ?????? ???????? ClickOnce. ?? ??? ??? ??????? ??? ??????? ???. ?? ??? ?????????? ?? ??? ????? ????? ????? ?? "??? ????? SQL Server ???".
???? ?????? ????? ??????? 1
??????? ?????? ??? ??? ??????? ?? ?????? ??? .xml ?????? ?????? ?? ClickOnce. ?? ???? ?????? ?? ????? ????? ????? ?? "??? ????? SQL Server ???" ??? ??? ???????.

?????? ??? ???? ?? ????????? ??? ????? ????? ????????? ??????? ?????? ??? ?? ?????? ???? ?????? ??? ????? ?????? ?????? Microsoft (MSDN):
http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx
(http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx)

??????? 2

???? ??? ????????? ??????. ????? ????? ????? ?????????? ?? "??? ????? SQL Server ???". ?? ?? ?????? ????? ????? ?? "??? ????? SQL Server ???" ??? ??? ???? ?????????. ?? ??? ?????????? ????? ??? ??????? ?????? ?? ????? Machine.config ??? ????? ????? "??? ????? SQL Server ???":
SQL Server ??? Edition ???? ????????
?????? ????? Machine.config ?? ?????? ??????:
Microsoft.NET\Framework\v2.0.50727\CONFIG%WinDir
?? ???? ??? ??????? ????? ?? ????????? agnostic ????.
???? ?????? ????? ??????? 2
?????? ??? ??? ???????? ?????? ???? ????? ???????:
  • ????? ??? Config.xml ?????? ????????.
  • ??? ??? ???? ?? ????? ????? ????? ????? ?? "??? ????? SQL Server ???" ????? ????? ??????? ????????? ?? "??? ????? SQL Server ???" ?????.
  • ????? ????????? ??????? ??? ?????? DbProviderFactories ?? ????? Machine.config ??????. 
    <add name="SQL Server Compact Edition Data Provider" invariant="System.Data.SqlServerCe" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

??????? 3

?? ????? ????? "????? ????? SQL Server ???" ?? Visual Studio 2005 ?????? ????? ?????? SP1 ????? ??? ??? ???????? ?????? ???????? ??? ??? ???? ?????????.

?????? ????? ????? Visual Studio 2005 ?????? ????? ?????? SP1 ????? ??? ??? ???????? ?????? ???????? ??? ??? ???? ?????????.

??????? 4

?? SQL Server ??? ??????? 3. 1? ?? ????? ??????? ??????? sp_repladdcolumn ????? ?????? ???????? ??????? ?? ????? SQL ?????:
  • ????? ???? ???? ??? ????.
  • ????? ??? ????? ????? ??? ???? ????. ???? ??????? ??????? ???? ?? ???? ?????.
??? ???? ??????? ?? ????? ????? ????? SQL ??????? ?? SQL Server ??? ??????? 3.1. 
Northwind..sp_repladdcolumn  @source_object='Customers' , @column='ColNew' , @typetext='int constraint FK_Foo_Customer foreign key  references Products ( ProductID )' , @publication_to_add='PubName')
???? ?????? ????? ??????? 4
????? ?????? SQL ????? ?????? ???????? ???? ?????.

??? ???? ??????? ????? ?????? SQL ??????? ?????? ?????? ???? ?????. 
EXEC Northwind..sp_repladdcolumn  @source_object='Customers' , @column='ColNew' , @typetext='int' , @publication_to_add='PubName';
Alter table Customers add constraint FK_Foo_Customer foreign key (ColNew) references Products ( ProductID )
??? ????? ?????? SQL ????? ????? ?????? ?????? ?? ??????? ?? ??????????.

??????? ???????

SQL Server ??? ??????? 3.1 ??? ?? ?????? ?? ??????? ???? ???? ?? ??????? SQL Server Edition ???. ???? ??????? ??????? ??? ??????? ???? ???? ??? ?? SQL Server ??? ??????? 3.1:
  • ??? ????? ??? ???? ?? ????????? ??????? ?? SQL Server Edition ???. ????? ??? ????? Visual Studio 2005 ?? SQL Server 2005 ??? ????? SQL Server Edition ???.

    ??? ?? ??? ??????? ?? SQL Server ??? ??????? 3.1. ??? ??? ?????? SQL Server ??? ??????? 3.1, ????? ????? SQL Server ??? Edition ???? ????? ?? Visual Studio 2005 ?? SQL Server 2005.
  • ??? ????? ?????? ????? NULL ?? ????? ????? ??????? SQL Server Edition ??? ?? ???? ???? ??????? ????????? ???? ?????? ?? ??? ????? ??????? ?? ???????. ????? ?? ???? ??? ????????? ??????? ?? SQL Server Edition ??? ????? ??????? ???????:
    ???? # <OrdinalNumber>
    ??? ???? ??????? ???? ????? ????? ???????. 
    Select c1 as Col1, NULL as Col2 from Table1
    ??? ????? ??? ??????? ?? ????????? ??????? ?? SQL Server Edition ??? ???? ?????? ????? ??????? ?? ???????:
    ???? # 0 ?????? # 1
  • ???? ??? ????????? ??????. ??? ????? ????? ON DELETE ??? ???? ?? ????????? ??????? ?? SQL Server Edition ???. ????? ?????? ??? ?? ???? ???. ??? ???? ????? ??? ???? ?? ??????. ??? ??? ???? ???? ??? ????. ?? ??? ?????????? ???? SQL Server Edition ??? ???? ???????? ???? ????? ??? ????. ???????? ??? ???? ??? ??? ???? ???? ?????? ?????? ?? ?????? ???? ????? ??? ???? ???????? ???, SQL Server Edition ??? ?????? ?????? ?????? ?? ???? ??????.
  • ??? ????? ??????? SQL Server Edition ??? ?? ????? ????? ????? ???????:
    ??? ?????? ??????? ?? ??????? ??????? ???????
    ???? ??? ??????? ??? ????? ???????? ?????????:
    • ????? SQL Server Edition ??? ????? ?????? ??? ???? ?????? ???? ?????? (btree).
    • ???? ?????? ?????.
    ?????? ????? ???? ?????? SQL Server Edition ??? ???????? ??? ???? ???? ?????? ? SQL Server Edition ??? ????? ?????? ???? ?????? ???? ??????. ?????? SQL Server Edition ??? ???? ????? ??????? ??? ????? ??????:
    • ?????? ??????
    • ????? ??????
    • ????? ??????
  • ?? ????????? ??????? ?? SQL Server Edition ??? ??? ??????? ??? ???? ??????? ???????? ?????? ?? ???? ???? ????? ???? (BLOB) ? ?? ???? ??? SSCE_M_COLUMNORDINALNOTFOUND.

    ???? ??? ??????? ???? ???? ?????? ??????? ?????? ???? ???? ????? ???????? ???? ????? ?? ???? ???????? "?????? ??? ?????? ?????? ???? ???? ?????. ?? ???? ??????? ???? ?????? ??????? ?? ????? ?????? ???? ???? ????? ???????? ?? ?????? ??????? ??????. ??? ???? ?? ?? ???? ?????? ??????? ? ???? ???????? "?????? ??? ??????? ?????? ??????? ???????? ???????? ?????? ?? ???? ???? ???? ?????.
???? ??? ?????? | ????? ???????

???????

???? ???????: 920700 - ????? ??? ??????: 08/???? ?????/1428 - ??????: 8.4
????? ???
  • Microsoft SQL Server 2005 Compact Edition
????? ??????: 
kbmt kbinfo kbexpertiseadvanced KB920700 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????920700
(http://support.microsoft.com/kb/920700/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????