search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

CREATE EXTERNAL TABLE for Oracle maps DATE to DATE in SQL Server #4379

Open jrowlandjones opened 5 years ago

jrowlandjones commented 5 years ago

Issue Type: Bug

Run CREATE EXTERNAL TABLE for Oracle Choose job history table Complete wizard Date columns in Oracle map to Date columns in SQL Server. They should be mapping to DATETIME2 as Oracle allows hours minutes and seconds in their data type.

Oracle reference

SQL reference

Azure Data Studio version: Azure Data Studio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:09:15.672Z) OS version: Darwin x64 18.2.0

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz (12 x 2600)| |GPU Status|2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: enabled
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|2, 1, 1| |Memory (System)|16.00GB (0.35GB free)| |Process Argv|/Applications/Azure Data Studio.app/Contents/MacOS/Electron| |Screen Reader|no| |VM|0%|
Extensions (1) Extension|Author (truncated)|Version ---|---|--- sql-vnext|Mic|0.10.2
darkmastermindz commented 4 years ago

Hi, is Oracle databases supported in data studio? How can I help contribute? #6724