Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
torlok2002
Starting Member
11 Posts |
 Posted - 2009-01-21 : 10:06:34
|
| Does Microsoft provide any client side query analyzer tools for free? I'm running MSSQL 8.0 on the server. If MS does not provide any tools, are there any good free (preferably OSS) client side tools with the ability to export data to .csv or excel from custom queries? Any guidance would be great. Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-21 : 11:09:31
|
| you can use ssis export import wizard available in sql express edition. |
 |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-21 : 11:17:12
|
| I'm not sure but is BCP available with SQL Express?To me that is the simplest way to export..If it is available I recommend you look into it. You can add the BCP commands to your custom query to dynamically create the csv file into a directory of your choosing.r&r |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-21 : 11:27:28
|
quote:
Originally posted by revdnrdy
I'm not sure but is BCP available with SQL Express?To me that is the simplest way to export..If it is available I recommend you look into it. You can add the BCP commands to your custom query to dynamically create the csv file into a directory of your choosing.r&r
yup. BCP is also available |
|
|
|
torlok2002
Starting Member
11 Posts |
Posted - 2009-01-21 : 12:37:55
|
| I guess I'm confused... You saying I can install SQL Express on my machine and use the query tool from that to connect to the server? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-21 : 12:39:58
|
quote:
Originally posted by torlok2002
I guess I'm confused... You saying I can install SQL Express on my machine and use the query tool from that to connect to the server?
yup. you can. |
|
|
|
torlok2002
Starting Member
11 Posts |
Posted - 2009-01-29 : 15:48:36
|
| thank you. I've actually started using dbvisualizer free, which has many great tools which makes it a lot easier to work with the data. |
|
|
|
|
|
|
Running Queries from workstation