Stack Overflow
Stack Overflow

Questions tagged [sql-data-tools]

22 questions
8
votes
3 answers

Sql Project Publish replaces Deploy - how to supress versioning and hook into tfs build

We're using the Sql Server 2012 SSDT which removed the deploy option in Visual Studio for the database projects (now sql projects). We'd like to automate the Publish step as we had for deploy, but it's not clear how to do this. so thA couple of…
Reuven Trabin
  • 451
  • 7
  • 18
4
votes
1 answer

pass SQLCMD variables to dbDacFx provider with msdeploy

I'm currently using msdeploy's dbDacFx provider to deploy a .dacpac to a database. The dacpac expects three SQLCMD variables. The syntax I am using looks like this: -setParam:kind=SqlCommandVariable,scope=Database.dacpac,match=foo1,value="foo1…
misterManager
  • 1,174
  • 4
  • 12
  • 33
4
votes
2 answers

Creating SQL Agent JOBs in SQL Server 2012 Database Projects from VS 2012

I am working on Visual Studio 2012 with Update 2 + SQL Server Data Tools and I am able work on the SQL Server Database Projects. How do I create/add new SQL Agent JOB into this database project? Because if I click Add - New Item... I don't see…
Prabhat
  • 4,164
  • 4
  • 17
  • 12
2
votes
2 answers

Unable to use the dimension table as a nested table in SQL server data tools

I have the following relationship set up between my fact table and dimension tables. When trying to create a data mining structure, I had to choose the dimension table Dimension_Status as a nested table for the fact table as I'm trying to predict…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
2
votes
2 answers

How to connect to Azure VM SQL Server Analysis Service Instance using a Developer Computer

I need a way to connect to an SQL Server Analysis Service default instance on Microsoft Azure Virtual Machine from my developer computer at home. I understand that i can only connect to Analysis Service using Windows Authentication and i haven't…
Komengem
  • 3,662
  • 7
  • 33
  • 57
1
vote
1 answer

why Visual studio 2019 missing SQL Service-Based-Database

I am trying to make a Login form in visual studio and I watched few videos and it says that I need to use the SQL server data tool/Service-Based-Database in the solution item section but seems like it's not there. I already checked and it is…
Mostafa Ghorbani
  • 397
  • 1
  • 3
  • 15
1
vote
1 answer

SSIS package doesnt work on server

I've made a package that works nicly on my dev-computer but when I copy the dtsx-file over to my SQL2014 it doesnt work properly. The Packages inkludes a OLE DB-source that runs a sql-question and stores the result into a resultset. I then have a…
Tomas H
  • 57
  • 7
1
vote
1 answer

Connecting Multidimensional Cube to PowerView

i am new to SSAS . we can connect tabular model in SSAS to powerview . Can we connect Multidimensional Cube(Datatools) also to Powerview without sharepoint Thanks
Jen
  • 11
  • 1
1
vote
0 answers

Oracle to SQL in SSIS - ETL

i am trying to get data from oracle database to sql database i have 3 environments Oracle development server 1 SQL development server 2 my local host window 8.1 64 bit with SQL data tool 2012 now when i go to add new connection manager under…
Noora
  • 319
  • 3
  • 10
  • 26
1
vote
1 answer

"Object reference not set to an instance of an object" when publishing a sql project VS 2013

When I try to publish a SQL Project to a database (SQL server 2008 r2) from Visual Studio 2013, I get a dialog box saying "Object reference not set to an instance of an object" and then the publish never finishes (the progress icon keeps…
Juan Tarquino
  • 967
  • 7
  • 13
1
vote
1 answer

How can I view contents in Sql Data Tools Visual Studio 2010?

I have a problem viewing binary data field in SQL query results. The field values are exactly MD5 falues. Is there any features in SQL Data Tools to view this data? Example is near…
Semant1ka
  • 647
  • 10
  • 26
0
votes
0 answers

How can I add SQL Data Tools to a Visual Studio 2015 Professional?

I already installed SQL Data Tools... datatools But in the Visual Studio 2015 can't find the option of Reports rdlc I tried Install SQL Data Tools and no more other stuff, tried to install sql data tools from visual studio instalation but I can't…
Lele Kun
  • 11
  • 1
0
votes
1 answer

Using core/model database with small changes on different installations for customization without duplicating code

As an example core database looks like this: Person - Id, FirstName, LastName Address - Id, Street, ZipCode This model is used on the majority of the installations but for a couple of installations I want to add customized columns, let's say the…
Westerlund.io
  • 2,743
  • 5
  • 30
  • 37
0
votes
0 answers

SSDT <> <>

I have been trying to deploy a solution from SQL Server Data Tools to my sql server. However, whenever I try to, i get the following error (I'm sorry its in french, the second screenshot in an equivalent of it I found online): I set up my server…
H. Ka
  • 1
0
votes
1 answer

Tool to extract specific data from a Oracle database (with over 100 tables) to another Oracle Database which has the structure but not the data

I have the following challenge: I have a large Oracle Database # 1 with 100 tables which are linked through one to many and many to many relationship. I need to copy only certain rows from the main Oracle Database # 1 into a Oracle Database #2…
user3049935
  • 11
  • 1
1
2