http://www.microsoft.com/download/en/details.aspx?id=26729

http://www.microsoft.com/download/en/details.aspx?id=8483

https://docplayer.pl/1015614-Migracja-bazy-danych-microsoft-access-mdb-do-microsoft-sql-2008-server-r2-sp1-dla-oprogramowania-platnik.html


msa2sql_5_5_0_281.exe - pozwala przenieść bazę do SQL


SELECT * FROM IMPORT
DELETE FROM IMPORT


!!! WYKONAJ
DELETE FROM DZIENNIK

!!! DODAJ POLA DO OSOBA_PRYWATNA
ADRESPOCZTYEL varchar(30).
WYBRANY varchar(1)

!!!!
POMIN: PARAM_KONF, UBEZP_KODTYT, UBEZP_NIEP,UBEZP_SCHEM

Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ADRESPOCZTYEL' varchar(30).
SQL: INSERT INTO [OSOBA_PRYWATNA] ([ID], [ID_UZYTKOWNIK], [NIP], [PESEL], [RODZDOK], [SERIANRDOK], [WOJEWODZTWO], [MIEJSCOWOSC], [KODPOCZTOWY], [ULICA], [NUMERDOMU], [NUMERLOKALU], [ADRESPOCZTYEL], [WYBRANY], [STATUSWR], [INSERTTMP]) VALUES (1, 0, '7711028924', '68040101200', '1', 'AMY766342', 'ŁÓDZKIE', 'LUTOSŁAWICE RZĄDOWE', '97306', NULL, '55', NULL, NULL, NULL, NULL, NULL)
Transfer was aborted

Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WYBRANY'. varchar(1)
SQL: INSERT INTO [OSOBA_PRYWATNA] ([ID], [ID_UZYTKOWNIK], [NIP], [PESEL], [RODZDOK], [SERIANRDOK], [WOJEWODZTWO], [MIEJSCOWOSC], [KODPOCZTOWY], [ULICA], [NUMERDOMU], [NUMERLOKALU], [ADRESPOCZTYEL], [WYBRANY], [STATUSWR], [INSERTTMP]) VALUES (1, 0, '7711028924', '68040101200', '1', 'AMY766342', 'ŁÓDZKIE', 'LUTOSŁAWICE RZĄDOWE', '97306', NULL, '55', NULL, NULL, NULL, NULL, NULL)
Transfer was aborted

Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'KONFIGUR_PK'. Cannot insert duplicate key in object 'dbo.PARAM_KONF'. The duplicate key value is (1).
SQL: INSERT INTO [PARAM_KONF] ([ID], [NAZWA], [WARTOSC1], [WARTOSC2], [WARTOSC3]) VALUES (1, 'WersjaBazy', '1002009', NULL, NULL)
Transfer was aborted


Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "UBEZP_KODTYT" because it does not exist or you do not have permissions.
SQL: SET IDENTITY_INSERT [UBEZP_KODTYT] ON

Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "UBEZP_NIEP" because it does not exist or you do not have permissions.
SQL: SET IDENTITY_INSERT [UBEZP_NIEP] ON

Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "UBEZP_SCHEM" because it does not exist or you do not have permissions.
SQL: SET IDENTITY_INSERT [UBEZP_SCHEM] ON