access MS SQL on a server from my local machine.

[john_zakaria]

Need small software, that access MS SQL on a server from my local machine.
After installing the proper software, i want to export the existing database in mssql

any idea?

[oesxyl]

Need small software, that access MS SQL on a server from my local machine.
After installing the proper software, i want to export the existing database in mssql

any idea?
what's the difference between mssql and MS SQL?

don't say that first is lowecase and second uppercase and have a space after ms, :)
best regards

[john_zakaria]

what's the difference between mssql and MS SQL?

don't say that first is lowecase and second uppercase and have a space after ms, :)
best regards

it is the same :) i mean that i need to export the data from MSSQL server in MSSQL on my machine

[oesxyl]

it is the same :) i mean that i need to export the data from MSSQL server in MSSQL on my machine
I don't use ms product so I don't know details about mssql. I try a google search for "copy mssql database" and give me this:

http://bytes.com/topic/sql-server/answers/78585-copy-database-one-sql-server-another

I hope will help

changing the query expresion to "software to copy mssql database" give me this:

http://www.softpedia.com/progDownload/MS-SQL-Server-Copy-Tables-to-Another-MSSQL-Database-Software-Download-109358.html

maybe is closer to what you ask.

best regards

[Old Pedant]

Where do you want to export the data *TO*???

You know, you *can* simply do a sp_detachdb, copy the resulting file, and then sp_attachdb to both the original DB and, after moving the copied file to the other server, and sp_attachdb there, as well.

Whether this is a good idea or not depends on how big the DB to be copied is and what the two installations of SQL Server look like, etc.