OK, yes, restore, but I can't find in SQL OS where to start a restore on a database I'm connected to. I have a.bak and a connection to a Db but I cannot see how to restore. Any help appreciated.
Related Software Categories: Applications | Business Finance | Database Management | E-mail | Inventory Systems | Legal | Market-Tracking Tools | More Business.. | MS Office | Other
Navicat for SQL Server is a powerful database administration and development tool for Microsoft SQL Server. It works with SQL Server 2000, 2005 and 2008R2, and supports most of the latest features. It also contains many advanced features like Data Modeling Tool, Import and Export, Debugger, Visual Query Builder, Data Transfer, Data and Structure Synchronization and Batch Job Scheduling.
- Powerful Visual Database Designer Data Modeling Tool allows you to create graphical representations of a relational database. The Reverse Engineer feature enables you to create a database model from an existing database and graphically visualize and edit the structure of the database. Or, you can graphically create a model, and generate a database that supports the model. - Excellent visual and text tools for query building Visual Builder allows you to build complicated queries without any knowledge of SQL syntax. You can also experience a quick way in constructing SQL statements in SQL Editor with the code/word completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list. - Impressive data export and import capabilities Navicat for SQL Server provides a robust set of features to insert new data into your database or extract data from it using a variety of formats to suit your purposes. You can import data into your databases from up to 5 most popular formats including XLS, XML, CSV, TXT and DBF to create new tables or update existing tables in your database. It also gives you complete control over the source data selected for export, allowing you to fine tune the content of the output with special refinement options for each format. - Powerful data manipulation tools Advanced data transferring feature brings you a new level of reliability in transferring data between databases. Moreover, Naivcat synchronization tools provide the ability for data in different databases to be kept up-to-date so that each repository contains the same information. Other useful features: - Native 64-bit version - Brand new UI design - Smart Find and Replace - Enhanced SSH Manager - Enhanced Connection Tree with filter - Over 100 new features and improvements
Platforms: 10.6 Snow Leopard or 10.7 Lion , Mac OS X 10.5 Leopard
System requirements: Not specified
Price: $159.00
Tags: Sql Server, SQL Server Download, SQL Server Database, Sql Server Editor, SQL Server GUI For Windows, SQL Server GUI For Mac, SQL Server Admin, SQL Server Software, SQL Server Frontend, Sql, Server Front, SQL Server Client, SQL Server Development, Sql Server Administrator, Sql Server Tool, Sql Server Management, Sql Server Administration, Sql Server Manager, Sql Server Expert, Sql Server Maestro, Sql Server Developer, Sql Server Database Manager, Sql Server Gui, Sql Server Gui Client, Sql Server Gui Tool, Ms Sql Server Management Tool, Sql Server Management Studio, Ems Sql Management Studio, Ms Sql Maestro, Toad For Sql Server, Sql Server Tools, Ms Sql Tools, SQL Azure, Sql Azure Database Manager, Sql Azure Migration, Sql Azure Management Tool, Sql Azure Administration, Sql Azure Client, Sql Azure Gui, Sql Azure Data Import Export, Sql Azure Administrator, Sql Azure Development, Sql Azure Reporting, Sql Azure Synchronization, Sql Server Er Diagrams, Database Design Tool, Data Modelling Tools, Dbwrench, Database Wide Search, Sql Code Minifier, Sql Ddl Script Generation
Navicat for SQL Server (Mac OS X) 11.0.0 user reviews
BRU Server for Mac 2.0
16 downloadsBRU Server for MacOSX is a native Macintosh
Navicat for SQLServer (MacOSX) - the best GUI database administration tool 11.2.8
43 downloadsNavicat for SQLServer - eminent database tool
MacOSXServer Web Password 0.9
123 downloadsMacOSXServer Web Password is a web application that allows users to change their Open Directory passwords via a web page
BRU for MacOSX 1.2.8 1. 2. 2008
28 downloadsAbout BRU for MacOS X Provides backup and
Web Help Desk Software for MacOSX 10.0.18.3
34 downloadsThe Web Help Desk software for MacOSX offers an industry leading web-based help desk software feature set that allows you to dynamically assign, track and fulfill all of your technical support trouble tickets and customer service requests with ease
Apple MacOSX Update 10.6.7
39 downloadsThe 10.6.3 Update is recommended for all users running MacOSX Snow Leopard and includes general operating system fixes
SMS Widget for MacOSX 1.0
45 downloadsSMS Widget for MacOSX from CardBoardFish is
Senomix Timesheets for MacOSX 4.1
16 downloadsSenomix Timesheets for MacOSX is the
MacOSX to PDF Converter 6.0
19 downloadsMacOSX to PDF Converter â A HOT Utility
Outlook Express to MACOSX 4.5
67 downloadsDo you need to move emails from Outlook Express to MACOS X?
Related Searches
Latest Software Searches
Active10 months ago
How can I connect to a remote SQL server using Mac OS X? I don't really need a GUI, but it would be nice to have for the color coding and resultset grid. I'd rather not have to use a VM.
Is there a SQL client for Mac OS X that works with MS SQL Server?
closed as not constructive by casperOneJul 3 '12 at 13:47
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
25 Answers
Let's work together on a canonical answer.
Native AppsJava-Based
Electron-Based
(TODO: Add others mentioned below)
The Java-based Oracle SQL Developer has a plugin module that supports SQL Server. I use it regularly on my Mac. It's free, too.
Here's how to install the SQL Server plugin:
This will be the second question in a row I've answered with this, so I think it's worth pointing out that I have no affiliation with this product, but I use it and love it and think it's the right answer to this question too: DbVisualizer.
I thought Sequel Pro for MySQL looked pretty interesting. It's hard to find one tool that works with all those databases (especially SQL Server 2005 . . . most people use SQL Server Management Studio and that's Windows only of course).
When this question was asked there were very few tools out there were worth much. I also ended up using Fusion and a Windows client. I have tried just about everything for MAC and Linux and never found anything worthwhile. That included dbvisualizer, squirrel (particularly bad, even though the windows haters in my office swear by it), the oracle SQL developer and a bunch of others. Nothing compared to DBArtizan on Windows as far as I was concerned and I was prepared to use it with Fusion or VirtualBox. I don't use the MS product because it is only limited to MS SQL.
Bottom line is nothing free is worthwhile, nor were most commercial non windows products
However, now (March 2010) I believe there are two serious contenders and worthwhile versions for the MAC and Linux which have a low cost associated with them. The first one is Aqua Data Studio which costs about $450 per user, which is a barely acceptable, but cheap compared to DBArtizan and others with similar functionality (but MS only). The other is RazorSQL which only costs $69 per user.Aqua data studio is good, but a resource hog and basically pretty sluggish and has non essential features such as the ER diagram tool, which is pretty bad at that. The Razor is lightning fast and is only a 16meg download and has everything an SQL developer needs including a TSQL editor.
So the big winner is RazorSQL and for $69, well worth it and feature ridden. Believe me, after several years of waiting to find a cheap non windows substitute for DBartizan, I have finally found one and I have been very picky.
My employer produces a simple, proof-of-concept HTML5-based SQL client which can be used against any ODBC data source on the web-browser host machine, through the HTML5 WebDB-to-ODBC Bridge we also produce. These components are free, for Mac, Windows, and more.
Applicable to many of the other answers here -- the Type 1 JDBC-to-ODBC Bridge that most are referring to is the one Sun built in to and bundled with the JVM. JVM/JRE/JDK documentation has always advised against using this built-in except in experimental scenarios, or when no other option exists, because this component was built as a proof-of-concept, and was never intended for production use.
My employer makes an enterprise-grade JDBC-to-ODBC Bridge, available as either a Single-Tier (installs entirely on the client application host) or a Multi-Tier (splits components over the client application host and the ODBC data source host, enabling JDBC client applications in any JVM to use ODBC data sources on Mac, Windows, Linux, etc.). This solution isn't free.
All of the above can be used with the ODBC Drivers for Sybase & Microsoft SQL Server (or other databases) we also produce ..
Squirrel SQL is a Java based SQL client, that I've had good experience with on Windows and Linux. Since it's Java, it should do the trick.
It's open source. You can run multiple sessions with multiple databases concurrently.
I vote for RazorSQL also. It's very powerful in many respects and practically supports most databases out there. I mostly use it for SQL Server, MySQL and PostgreSQL.
DbVisualizer supports many different databases. There is a free edition that I have used previously. Download from here
I have had good success over the last two years or so using Navicat for MySQL.The UI could use a little updating, but all of the tools and options they provide make the cost justifiable for me.
I like SQLGrinder.
It's built using Cocoa, so it looks a lot better and feels more like an Mac OS X application than all the Java-based application mentioned here.
It uses JDBC drivers to connect to Microsoft SQL Server 2005, FrontBase, MySQL, OpenBase, Oracle, PostgreSQL, and Sybase.
Free trial or $59.
I use the Navicat clients for MySQL and PostgreSQL and am happy with them. 'good' is obviously subjective.. how do you judge your DB clients?
I've been using Oracle SQL Developer since the Microsoft software for SQL Server is not currently available on Mac OS X. It works wonders. I would also recommend RazorSQL or SQLGrinder.
I use AquaFold at work on Windows, but it's based on Java and supports Mac OS X.
I've used (DB Solo) and I like it a lot. It's only $99 and comparable to many more expensive tools. It supports Oracle, SQL Server, Sybase, MySQL, PostgreSQL and others.
Not sure about open-source, but I've heard good things about http://www.advenio.com/sqlgrinder/ (not tried it, I prefer to write Python scripts to try things out rather than use GUIs;-).
When this question was asked, Microsoft's Remote Desktop for OS X had been unsupported for years. It wasn't a Universal Binary, and I found it to be somewhat buggy (I recall that the application will just quit after a failed connection instead of allowing you to alter the connection info and try again).
At the time I recommended the Open Source CoRD, a good RDP client for Mac.
Since then Microsoft Remote Desktop Client for Mac 2 was released.
I use Eclipse's Database development plugins - like all Java based SQL editors, it works cross platform with any type 4 (ie pure Java) JDBC driver. It's ok for basic stuff (the main failing is it struggles to give transaction control -- auto-commit=true is always set it seems).
Microsoft have a decent JDBC type 4 driver: http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en this can be used with all Java clients / programs on Win/Mac/Lin/etc.
Those people struggling with Java/JDBC on a Mac are presumably trying to use native drivers instead of JDBC ones -- I haven't used (or practically heard of) the ODBC driver bridge in almost 10 years.
It may not be the best solution if you don't already have it, but FileMaker 11 with the Actual SQL Server ODBC driver (http://www.actualtech.com/product_sqlserver.php) worked nicely for a client of mine today. The ODBC driver is only $29, but FileMaker is $299, which is why you might only consider it if you already have it.
This doesn't specifically answer your question, because I'm not sure in any clients exist in Mac OS X, but I generally just Remote Desktop into the server and work through that. Another option is VMware Fusion (which is much better than Parallels in my opinion) + Windows XP + SQL Server Management Studio.
I've used Eclipse with the Quantum-DB plugins for that purpose since I was already using Eclipse anyway.
Sql Server For Mac Os
Ed: phpMyAdmin is for MySQL, but the asker needs something for Microsoft SQL Server.
Most solutions that I found involve using an ODBC Driver and then whatever client application you use. For example, Gorilla SQL claims to be able to do that, even though the project seems abandoned.
Most good solutions are either using Remote Desktop or VMware/Parallels.
Try CoRD and modify what you want directly from the server.
It's open source.
Sql Tool For Mac Okc
For MySQL, there is Querious and Sequel Pro. The former costs US$25, and the latter is free. You can find a comparison of them here, and a list of some other Mac OS X MySQL clients here.
Sql Server On A Mac
Steve
Since there currently isn't a MS SQL client for Mac OS X, I would, as Modesty has suggested, use Remote Desktop for the Mac.
Itool For MacNot the answer you're looking for? Browse other questions tagged sql-servermacos or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |