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.53k stars 896 forks source link

dacpac export error #4358

Closed ralphke closed 5 years ago

ralphke commented 5 years ago

Issue Type: Bug

Tryed to export my SQL DW database to my local file an received the following error: Extract dacpac: Could not extract package from specified database. Parse error at line: 1, column: 5: Incorrect syntax near 'ANSI_NULLS'.

Azure Data Studio version: azuredatastudio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:20:08.633Z) OS version: Windows_NT x64 10.0.17763

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz (4 x 2496)| |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: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled| |Memory (System)|7.93GB (2.47GB free)| |Process Argv|C:\Program Files\Azure Data Studio\azuredatastudio.exe| |Screen Reader|no| |VM|0%|
Extensions (7) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.1 agent|Mic|0.36.1 import|Mic|0.5.0 profiler|Mic|0.6.0 server-report|Mic|0.1.5 sql-dw|Mic|0.0.1 whoisactive|Mic|0.1.1
kisantia commented 5 years ago

SQL DW is not currently supported by DacFx. As of now, it is in public preview. It will be added in DacFx after it is officially released. Thanks!