SSDT 2014 (SSMS) BIDS (Visual Studion 2012 or 2013

Question

SSDT 2014 (SSMS) BIDS (Visual Studion 2012 or 2013

Welsh Corgi

SSC Guru

Points: 116520
More actions
December 31, 2014 at 7:54 am

#313326

I install SQL Server 2014, both the Client and Server tools on a Windows 2012 Windows Server.
I'm not straight about SSDT or the replacement for BIDS?
I have a SSDT for 2012 but I can't find the one for 2014.
I install it ok weeks ago but I'm trying to install the client on another PC.
Any help would be greatly appreciated.
Happy New Year. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246742 More actions · Answer 1

Is this what you are looking for?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Phil Parkin (12/31/2014)
Is this what you are looking for?

Yes, I believe that is for the BI tools.

What about the client tools? I just want to install SSMS 2014 and the Import and Export Data. What do I need to do that?

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Phil Parkin SSC Guru Points: 246742 More actions · Answer 3

Have a look here and look for 'SQL Server Management Studio Express'

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Phil Parkin (12/31/2014)
Have a look here and look for 'SQL Server Management Studio Express'

I can't just install the client, right?

Our users are uses to having the full client.

I just purchased SQL Server 2014 a few minutes ago.

Thanks again.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Phil Parkin SSC Guru Points: 246742 More actions · Answer 5

Yes you can.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Phil Parkin (12/31/2014)
Yes you can.

Thanks again.

Where is the download for the SQL Server 2014 Client?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Phil Parkin SSC Guru Points: 246742 More actions · Answer 7

Welsh Corgi (12/31/2014)
Phil Parkin (12/31/2014)
Yes you can.
Thanks again.
Where is the download for the SQL Server 2014 Client?

If you mean the management tools, you should follow the link I sent previously. (If 'SQL Server 2014 Client' means something else to you, please elaborate.)

Click on Download and scroll to the end of the "Choose the download you want" list.

PS I found all of this out via Internet searches – it's not stuff I know off the top of my head.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

Well thanks. I have been searching too but I'm uncertain that what I have found is what I need.

I'm not sure which link I need. I need the BI tools but I need the full blown Client Tools.

i.e when I click on programs > SQL Server 2014 I should see Download Microsoft SQL Server Compact, SQL Server Import Export 32 and 64 bit and SQL Server Management Studio.

With SQL Server 2008 you would just run the Setup Program and click on client tools.

I believe that I need SQL Server 2014 SSDT but I can only find the 2012 version.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

It turns out that I have 32 bit and 64 bit clients. So I need the Client Tools for both OS's.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/