Lm th? no ? chuy?n ?i m?t c s? d? li?u Access to SQL Server

D?ch tiu ? D?ch tiu ?
ID c?a bi: 237980 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

TM T?T

Cch d? nh?t ? chuy?n ?i m?t c s? d? li?u Access to SQL Server l s? d?ng thu?t s? Upsizing. Thu?t s? Upsizing:
  • B?o t?n c s? d? li?u c?u trc, bao g?m d? li?u, l?p ch? m?c, v thi?t ?t m?c ?nh.
  • T? ?ng chuy?n ?i quy t?c xc nh?n ti?p c?n v m?c ?nh thi?t ?t cho tng ng SQL Server thch h?p.
  • Duy tr? cc m?i quan h? b?ng v ton v?n referential sau khi b?n upsize.
? ch?y thu?t s? Upsizing trong Access 2000, trn cc Cng cu tr?nh n, i?m ?n C s? d? li?u ti?n ch, v sau b?m Upsizing Wizard.

S? d?ng Upsizing Thu?t s? trong truy c?p 97, b?n ph?i ?u tin t?i Microsoft Access Upsizing Cng c? 97 t? sau Web site c?a Microsoft:
http://www.Microsoft.com/downloads/details.aspx?FamilyID=f5c7a907-7c5f-46cb-9157-a1ec4e96083d&displaylang=en

? ch?y thu?t s? Upsizing truy c?p 97, trn cc Cng cu tr?nh n, i?m ?n Trinh b sung, v sau nh?p vo Upsize cho SQL Server.

N?u b?n c m?t phin b?n c? truy c?p, b?n c th? s? d?ng ho?c l m?t trong nh?ng phng php sau y:
  • Nng c?p ? truy c?p 97 ho?c Access 2000, v sau ch?y cc Upsizing Wizard.
  • S? d?ng SQL Server d? li?u bi?n ?i d?ch v? (DTS) ? chuy?n nh?p d? li?u t? c s? d? li?u truy c?p c?a b?n ?n m?t c s? d? li?u SQL Server. ? bi?t thm thng tin v? DTS v DTS Import Wizard, xem "Data Transformation Cc ch? ? d?ch v?"v"B?ng cch s? d?ng the nh?p kh?u v xu?t kh?u Wizards"trong SQL Server 7.0 Sch tr?c tuy?n. V d?, xem cc "nh?p d? li?u t? an Access Database V d?"ch? ? trong SQL Server sch tr?c tuy?n.
N?u b?n ang s? d?ng truy c?p 97 qua Access 2003, cng v?i SQL Server 2005, b?n c?ng c th? dng SQL Server Migration Assistant ? truy c?p. ? bi?t thm thng tin v? SQL Server Migration Assistant ? truy c?p, truy c?p vo cc Microsoft Web site sau:
http://www.Microsoft.com/sqlserver/2005/en/US/Migration-Access.aspx

Truy c?p 2000

Trong truy c?p 2000, trn cc Tp tr?nh n, i?m ?n M?i, v sau nh?p vo D? n m?i t? hi?n t?i Co? so? du? lie?u. Ty ch?n ny t?o ra m?t x? l? d? li?u t? ?ng (ADP) ?ng d?ng. ?ng d?ng ny t? ?ng s? d?ng cng c? my tnh ? bn my ch? SQL (c?ng ?c g?i l MSDE 2000) ho?c SQL Server nh my ch? v s? d?ng ADP t?p tin nh cc ?ng d?ng.

Chu y Khi b?n ch?y thu?t s? Upsizing t? truy c?p 97 ho?c Access 2000 ? SQL Server 2000, b?n c th? nh?n ?c m?t l?i "Trn". ? bi?t thm chi ti?t, nh?p vo s? bi vi?t sau ? xem cc bi vi?t trong c s? ki?n th?c Microsoft:
279454"Trn" l?i tin nh?n khi b?n c? g?ng upsize cho SQL Server 2000
272384 "Trn" thng bo l?i khi b?n c? g?ng upsize cho SQL Server 2000
Cho bi?t thm thng tin v? cc v?n ? gi?a Access 2000 v SQL Server nm 2000, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
269824M t? c?a s? khng tng thch cc v?n ? gi?a Access 2000 d? n (* .adp) v SQL Server 2000
Bi vi?t sau y c th? gip b?n chuy?n nh?p c?a b?n Truy c?p ?ng d?ng cho SQL Server:
  • Vi?c thi?t k? cc ?ng d?ng hi?u qu? cho Microsoft SQL Server: Gi?y tr?ng ny gi?i thch l? do t?i sao l?p ch? m?c truy nh?p tu?n t? phng php (ISAM) thi?t k? ?ng d?ng khng ph?i l thch h?p cho SQL Server.
    http://msdn2.Microsoft.com/en-us/Library/aa226307 (SQL.70) .aspx
  • Di chuy?n c s? d? li?u truy c?p Microsoft SQL Server 7.0: Gi?y tr?ng ny bao g?m thu?t s? Upsizing, bao g?m thng tin v? thi?t k? thay ?i v h?n ch? c?a tr?nh wizard.
    http://technet.Microsoft.com/en-us/Library/cc917601.aspx

Truy c?p 97

? bi?t thm v? Microsoft Access Upsizing Tools 97, gh thm Web site sau c?a Microsoft:
http://www.Microsoft.com/downloads/details.aspx?FamilyID=f5c7a907-7c5f-46cb-9157-a1ec4e96083d&displaylang=en
? t?i v? Microsoft Access Upsizing Tools 97, truy c?p vo cc Microsoft Web site sau:
http://www.Microsoft.com/downloads/details.aspx?FamilyID = f5c7a907-7c5f-46cb-9157-a1ec4e96083d
? bi?t thm thng tin, h?y b?m vao s? bi vi?t sau ? xem bi vi?t trong C s? Ki?n th?c Microsoft:
176614Microsoft Access 97 Upsizing Tools c s?n
279454 "Trn" thng bo l?i khi b?n c? g?ng upsize cho SQL Server 2000

THAM KH?O

Cho bi?t thm thng tin v? di chuy?n m?t c s? d? li?u truy c?p ? SQL Server, gh thm Web site sau c?a Microsoft:
http://MSDN.Microsoft.com/en-us/Library/aa139985.aspx

Thu?c tnh

ID c?a bi: 237980 - L?n xem xt sau cng: 17 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 97 Standard Edition
  • Microsoft Access 2.0 Standard Edition
T? kha:
kbsqlsetup kbhowtomaster kbhowto kbinfo kbmt KB237980 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:237980

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com