You mean SQL Server (a.k.a SS) right? SS 2000 ships with its own Access
tools (as do most big RDMS). Check out SQL Grinder for OS X. One note,
you'll need either an ODBC or JDBC driver before being able to access a
SS 2000 database. I haven't been able to get the JDBC drivers to work
so I've used an ODBC driver (from OpenLink). One you've got an ODBC
driver in place any client that can use an ODBC connection will work.
If you're on the Mac side, think about terminal servicing in. You can
download the Mac terminal services client for free from Microsoft. Then
you can use Query Analyzer (a.k.a QA) on your Win32 box.
If you have a Win32 emulator on your Mac, just install the SQL (server)
tools.
Regards,
Adam
On Sunday, October 12, 2003, at 09:41 PM, Jon Bell wrote:
Thanks, Lucas.
I didn't create the procedures in the first place, so I'll need to
check to see if there's any encryption. I'm still not clear on the
actual program I would use to see these procedures, however.
I use phpmyadmin and macsql for managing mysql databases, but SQL is a
different beast. I would expect to be able to do an export of all
data, and I would expect the stored procedures to be in table like all
the other data. Is this wrong? What app would you use (Mac or
Windows) to see and download these procedures?
Thanks,
Jon
On Sunday, October 12, 2003, at 06:42 AM, Lucas Holt wrote:
You probably didn't move the stored procedures when you changed
servers.
There are several ways to do a move.. the best being to get the
physical files for the database and install them on the new sql
server. The catch is that you will have permissions issues and need
to screw with usernames.
The Microsoft way to do it would be to use replication. The problem
with that is you really need sa access on both servers to pull it off
and get everything including stored procedures and maintenance plans.
If you just moved the data, you could recreate each stored procedure
by viewing them on the old server and then copy/paste into the new
one. This won't work if you used encryption when you saved them
though. (provided you didn't keep a backup of stored procedures in a
text file somewhere)
I'd also check to see if you missed any views if you use them.
Lucas Holt
email@hidden
________________________________________________________
FoolishGames.com (Jewel Fan Site)
JustJournal.com (Free blogging)
"Only two things are infinite, the universe and human stupidity, and
I'm not sure about the former."
- Albert Einstein (1879-1955)
_______________________________________________
web-development mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/web-development
Do not post admin requests to the list. They will be ignored.
_______________________________________________
web-development mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/web-development
Do not post admin requests to the list. They will be ignored.
