SQL Server , , . . .
SQL Server. ( .) Microsoft , , , , - - . SQL Server , .
SQL Server , . Windows XP Vista, Windows, SQL Server. (Knowledge Base) Web- http://support.microsoft.com/kb/914277.
, , SQL Server . . SQL Server , . . , .
SQL Server Express? .
■ SQL Server , , . ( , Windows (Administrators).)
■ Mixed mode... ( ...), , sa, .
, SQL Server , - . , , SQL Server, Windows- ( , , , (Guests),
(Administrators) (DatabaseLovers) . .). Windows, . , SQL Server . , SQL Server Management Studio (. . 20.2). SQL Server Management Studio Help ( ) , SQL Server.
|
|
, , , SQL Server . , . , , , , .
SQL Server
. SQL Server.
Access SQL Server:
■ Access . SQL Server;
■ Access SQL Server.
, , , . ( , Access SQL Server , Access. , , , - CD- . , , .)
. , , . Access SQL Server (, , ). SQL Server, .
.
Access SQL Server (Upsizing wizard), Access SQL Server. , . Access, , ,
. ( ), SQL Server.
.
1. , .
Database Tools → Move Data → SQL Server ( → → SQL-Server)1.
2. (. 20.5).
. 20.5. Access SQL Server
3. Create new database ( ) Next ().
SQL Server SQL Server (, ), Use existing database ( ) Access . . , SQL Server, .
|
|
4. (. 20.6) Access, . .
, SQL Server, , SQLEXPRESS. , SQL Server, FudgeServer, FudgeServer\SQLEXPRESS. SQL Server
1 Access. .
( Express), , , , Fudge-Server. . |
. 20.6. Access , MYSERVER, SQL Server Express
, (My Computer) ( (Windows Explorer)), (Properties). (Computer Name). ... (Change), .
5. Use Trusted Connection ( ).
Access Windows. , , .
6. Next ().
, - , .
, SQL Server ( , ). . , (, BoutiqueFudge). SQL Server , , .
7. , (. 20.7), Next ().
Access , . , . , , .
. 20.7. > Export to SQL Server
8. SQL Server (. 20.8). Next ().
2 , 4 . , Access, SQL Server , . , .
□ Table relationships ( ). , SQL Server , . . Use DRI (DRI), DRI data relational integrity ( ), , , . Use triggers () SQL Server .
|
|
□ Add timestamp fields to tables? ( ?) , . , . . , - , . . , , .
. 20.8. , Next, , . , ,
Only create the table structure... ( ...). SQL Server, . , Access , .
9. , Access. Create a new Access client/server application ( Access).
.
Create a new Access client/server application ( Access). , Access , Access. , . . adp. , , , , , . ( Access , , , , SQL Server.)
Link SQL Server tables to existing application ( SQL Server ). Access , , . , , "local" () ( , Products Products_iocal). , . SQL Server. ,
, , , , . ( . " . Access no " .)
No application changes ( ). , Access . : Access SQL Server ( Access). , .
10. Next ().
Access ( ), Access , . , .
11. Finish () , .
|
|
Access SQL Server . (. 20.9).
Access , . Print Preview → Close Preview → Close Print Preview ( → → ) .
. 20.9. - ,
. . , .
■ . .
■ . , , , .
■ . , . , , SQL Server. , , .
Access ( ), . , SQL Server :
■ (. 8) ;
■ ;
■ , , . ( , .);
■ , SQL-, , .