1. Install dulu SSMA for Access.6.0.0
Jika belum ada download di :
https://www.microsoft.com/en-us/download/confirmation.aspx?id=43690
2. Next
3. I accept the agreement >> Next
4. Pilih Complete
5. Finish
6. Buat database kosong dulu di SQL
7. Buka aplikasi
8. Next
9. Tentukan nama project dan migrate ke SQL versi berapa
10. Add Database
11. Pilih access database
12. Next
13. Next
14. Next
15. Next
16. OK
17. Testing dengan melakukan select table di database hasil migrate
Test table dengan select
select * from [dbo].[ACCOUNT CATEGORY]
select * from [dbo].[ACCOUNT MASTER]
18. Make SP VIEW
Karena di MS Access membuat SP View sulit / tidak bisa , olehnya di buat di SQL Server
create view
ABC_Account_Maintenance
as
select
[Account Number],
[Account Description],
[Account Alias],
case [Allow Account Entry]
when 0 then 'No'
when 1 then 'Yes'
else ''
end [Allow Account Entry],
[Account Category Number],
case [Posting Type]
when 1 then 'Balance Sheet'
when 2 then 'Profit and Loss'
else ''
end [Posting Type],
case [Typical Balance]
when 1 then 'Debit'
when 2 then 'Credit'
else ''
end [Typical Balance]
from dbo.[ACCOUNT MASTER]
go
GRANT SELECT ON ABC_Account_Maintenance TO
DYNGRP
SIMULATION GUIDE DONE
Semoga bermanfaat,
Informasi detail dapat hubungi saya di : HP : 085817961453
Tidak ada komentar:
Posting Komentar