Can I access SQL Server from client Linux?
And Any functions in Postgre are in SqlServer?By access to you mean that you want to code a program to connect to and
work with SQL Server? If so, then yes...If you're on Linux you'll have
to use ODBC or JDBC (if you have the JDBC driver for SQL Server
installed on the machine hosting SQL Server) and the appropriate
connection string (which I don't remember right now, sorry, but it
should be somewhere if you Google it or probably someone in the
newsgroup remembers it) in your program.
If you want something that you can use to manager/administrate your SQL
Server from Linix (like Enterprise Manager/Management Studio as you
would have on Windows) then sorry but I am not aware of any tools out
there for this purpose. Maybe someone else can help on this?
As for Postgre functions in SQL Server. Well, I'm not sure...All the
standard SQL you know should cross over fine but I would suggest taking
a bit of time to learn Transact-SQL and what it has to offer (or at
least have a reference handy). Thankfully, SQL Server Books Online can
be accessed from the web on:
SQL Server 2005: http://msdn2.microsoft.com/en-us/library/ms130214.aspx
SQL Server 2000:
http://msdn.microsoft.com/library/d...
ap1.asp
Hope that helps a little but sorry if it didn't
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment