No announcements
-
0 Votescode behind for SQL unit tests generated inconsistently
When creating SQL unit tests, the c# code that gets generated has a couple of issues. The first is that the first test function gets generated without a try finally statement, where ...
-
0 Votes
VS 2015 Database Project - Added Columnstore index but not all options are showing in deployment script
--This topic was moved from here I added a new Columnstore index to my database project but when I deploy it, two of the options I selected are ... -
2 Votes
Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors
System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ...Unanswered | 4 Replies | 54 Views | Created by Lyle6 - Tuesday, July 18, 2017 8:11 PM | Last reply by Grant Fritchey - Wednesday, July 19, 2017 6:11 PM -
0 Votes
SQL Database Migration
I need to move my client SQL Server databases to another cloud service so i need a software that does multiple database migration. All the ones i have found can only move 1 database at a time. i have ... -
0 Votes
microsoft ole db provider for db2 with zos version 11
Ran into an issue with SSIS packages using the microsoft ole db provider for db2 version 4.0 (SQL server 2012) or 5.0 (SQL server 2014). Recently upgraded db2 z/os to version 11, and now the ...Answered | 4 Replies | 228 Views | Created by bukkybu - Friday, February 17, 2017 2:53 PM | Last reply by hkni - Wednesday, July 19, 2017 12:56 PM -
0 Votes
VS2017 SQL Project build throws error about in-line constraints with FILESTREAM_ON when I try to setup a CLUSTERED PK on the table
Here's the error I get: SQL71565: In-lined constraints do not support the FILESTREAM_ON clause. The FILESTREAM_ON clause must be added to the table or the constraint must not be ... -
0 Votes
SQL46010 backup to url
Hello, I'm getting a SQL46010 error when I try to compile a sqlproj with a store procedure that uses BACKUP TO URL. The syntax is correct though as it runs in ...Unanswered | 6 Replies | 270 Views | Created by Clement83 - Monday, March 21, 2016 8:34 PM | Last reply by Anwarkhan GS - Tuesday, July 18, 2017 5:56 AM -
0 Votes
Schema Compare and "Include composite objects"
Hi All, I'm hoping somebody can shed some light on a small issue i'm having. I have a old database that I've imported into SSDT as ... -
0 Votes
SSDT Publish Failure
Hi, We have been having an issue with the SSDT publish with the following error Publishing to database 'DB' on ... -
1 Votes
SSMS 2016 Unattended Install Does Not Work Correctly
Hi I am doing an unattended install with the latest version from the blog below. It mentions an enhancement as follows "Improvements in the SSMS installer to ...Unanswered | 3 Replies | 785 Views | Created by SteveJC - Thursday, June 16, 2016 11:08 AM | Last reply by SQL_Duck - Friday, July 14, 2017 6:59 PM -
0 Votes
Opening SSIS package from Visual Studio 2015
Hello, When I open the DTS package in Visual Studio 2015 all I see is XML. I downloaded the SQL Server data tool set. Where can I find SQL ... -
0 Votes
SSDT for a MAC
Is this version of SSDT available for a MACUnanswered | 1 Replies | 47 Views | Created by PfoundsGannon - Friday, July 14, 2017 8:47 AM | Last reply by Olaf Helper - Friday, July 14, 2017 9:34 AM -
0 Votes
SSDT does not support table partitioning
I am using SSDT (VS2015) for a database project to create new tables which are partitioned. Here is an example of the script to created a partitioned ...Answered | 2 Replies | 73 Views | Created by Guoxiong - Wednesday, July 12, 2017 3:33 PM | Last reply by Guoxiong - Wednesday, July 12, 2017 8:25 PM -
0 Votes
Import excel to SQL through tasks->import-data - Edit SQL button unavailable
import data on database. As data source I choose Microsoft excel. As destination I choose SQL 'SQL Server Native Client ...Unanswered | 2 Replies | 89 Views | Created by kordix - Thursday, July 06, 2017 6:17 AM | Last reply by kordix - Wednesday, July 12, 2017 6:16 AM -
1 Votes
Data is Null when listing tables in database of SQL Server Express 2016 with SSMS 17.x
Hi I've been running SQL Server Express 2016 on my dev box ever since it came out. When SMSS 17 was released, I installed it, but the first database I wanted to "open" (as ...Unanswered | 1 Replies | 123 Views | Created by Stephan D Steiner - Monday, June 26, 2017 7:42 PM | Last reply by Bent M. Jensen - Tuesday, July 11, 2017 9:23 AM -
71 Votes
Schema Compare - Target unavailable
I'm experiencing a strange issue comparing schemas. I have VS2015 and am comparing two SQL2014 databases. After working fine for some time without explanation I now receive a message: ...Proposed | 32 Replies | 11401 Views | Created by ekephart - Monday, March 07, 2016 10:31 PM | Last reply by Phil Seeman - Tuesday, July 11, 2017 5:38 AM -
0 Votes
sqlpackage.exe and db automation in software delivery process
Hi, We have been using sqlcompare from redgate to handle CI db syncs and creating build to build migration scripts automatically. With this process we can ...Unanswered | 1 Replies | 102 Views | Created by Lance Lyons - Thursday, July 06, 2017 6:52 PM | Last reply by Vinay Manikanda - Tuesday, July 11, 2017 3:04 AM -
0 Votes
script task - connect to HTTP server and save response
Hello All, Is this possible to do a script file in SSIS package. In the package the HTTP connection or URL to be dynamically created from variables and then also ... -
7 Votes
New Red Gate SQL Compare beta release with SSDT support
Over the last few months, we at Red Gate have been working towards adding SQL Server Database Project compatibility to our main comparison tool, SQL Compare. I’m pleased to announce a beta ...Discussion | 20 Replies | 5832 Views | Created by james.allison - Thursday, January 03, 2013 11:16 AM | Last reply by Lance Lyons - Friday, July 07, 2017 3:22 PM -
1 Votes
Problem when refreshing a Data Source View using Visual Studio 2017
Hi, I am using Visual Studio 2017 to modify an Analysis Services project. I have made a change (added a new column) to one of the underlying tables in the Data ... - Items 1 to 20 of 3500 Next ›
No announcements
