Witam serdecznie,
Mam taki zrzut z bazy danych:
USE [DWH_NL_REF]
GO
/****** Object: Table [dbo].[REF_Postcode_NL] Script Date: 03/09/2016 11:35:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[REF_Postcode_NL](
[id] [float] NULL,
[postcode] [nvarchar](255) NULL,
[postcode_id] [float] NULL,
[pnum] [float] NULL,
[pchar] [nvarchar](255) NULL,
[minnumber] [float] NULL,
[maxnumber] [float] NULL,
[numbertype] [nvarchar](255) NULL,
[street] [nvarchar](255) NULL,
[city] [nvarchar](255) NULL,
[city_id] [float] NULL,
[municipality] [nvarchar](255) NULL,
[municipality_id] [float] NULL,
[province] [nvarchar](255) NULL,
[province_code] [nvarchar](255) NULL,
[lat] [float] NULL,
[lon] [float] NULL,
[rd_x] [float] NULL,
[rd_y] [float] NULL,
[location_detail] [nvarchar](255) NULL,
[changed_date] [datetime] NULL,
[geographypoint] AS ([geography]::STGeomFromText(((('POINT('+CONVERT([varchar](20),[lon],(0)))+' ')+CONVERT([varchar](20),[lat],(0)))+')',(4326)))
) ON [PRIMARY]
GO
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23082, N'1185XE', 11858869, 1185, N'XE', 2, 14, N'even', N'Bovenkerkerweg', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2841851341781, 4.8429645934418, 117863.198857142, 477493.264714285, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23083, N'1185XJ', 11858874, 1185, N'XJ', 163, 471, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2906822356276, 4.844411817959, 117967.36141081, 478215.397416216, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23084, N'1185XK', 11858875, 1185, N'XK', 9, 49, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2884812295665, 4.843539868722, 117906.036648148, 477970.957222222, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23085, N'1185XL', 11858876, 1185, N'XL', 51, 99, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.288406240247, 4.8437956701478, 117923.427, 477962.483, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
Orientujecie się może co to jest za format bazy danych? W jaki sposób można to najprościej przekonwertować i wrzucić do MySQL?