Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

SQL server data tools for VS 2017

hi,

it seems that MS only release SQL server data tools for VS 2015 so that we can admin and develop even SSIS project within VS 2015, how about VS 2017?

it seems we don't have this option to develop SSIS package inside VS2017, am I right?
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

HainKurt

"I just downloaded Data Tools and installed and can use it in my VS 2015..."

tks. but my question is ", how about VS 2017?"

"from MS product page:"

yes, but it seems not applicable ! how can you manage the SSIS package from within VS 2017, how about manage AS in VS 2017.

I just want to test if it can manage the SSIS and AS component inside my SQL 2014 DB.
from VS, file - new - project
then select Templates - Business Intelligence ...

do you have that menu?

User generated image
also, you can install VS 2015 and 2017 on the same machine...

Install Visual Studio Versions Side-by-Side
https://msdn.microsoft.com/en-us/library/ms246609.aspx
"do you have that menu?"

in VS2017, I don't have that Business intelligence menu.

do you think if install VS 2015 and VS 2017 on the same computer, it will give this problem.
did you install SQL Data Tools?

that menu appears after installing SSDT

I guess, when you have VS2015 + VS2017, it will be visible on both...
or, it may ask when you install, not sure...
"did you install SQL Data Tools?"

yes

"I guess, when you have VS2015 + VS2017, it will be visible on both..."

what I found out in 3 x  PC I install with this configuration is , cloud explorer doesnt' work any more, when I expand the data lake project, the VS 2017 will keep asking me to upgrade data lake component , but that upgrade is for vs 2015 only!
"also, you can install VS 2015 and 2017 on the same machine..."

can you try if cloud explorer for data lake can work as expected?

I can see if I use Vs 2015 with cloud explorer alone it works, once I install VS 2017, it doesn't works any more.
any other idea?
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Victor, I am having some question and discuss with other experist on MySQL multi master/ active active, join if you like.

tks for your help.
tks both.