Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

setting up Sybase, converting from Oracle

2 posts in Windows NT Last posting was on 1998-03-30 13:07:16.0Z
Jon Greisz Posted on 1998-03-27 15:07:23.0Z
From: jgg@dbmicro.com (Jon Greisz)
Subject: setting up Sybase, converting from Oracle
Date: Fri, 27 Mar 1998 09:07:23 -0600
Message-ID: <MPG.f8572b2463b4d8298968e@forums.powersoft.com>
Organization: DB Microware, Inc
X-Newsreader: Anawave Gravity v2.00.753
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5093
Article PK: 1092457

We develop custom software. Our applications currently
use Oracle & SQL Anywhere. I run an instance of Oracle
for each client. Within each instance I use a schema
name of ARCS. My application references all tables with
this schema name.

I'm trying to setup Sybase System 11 running on NT 4.

I'v installed and setup a couple of devices, one for
data, one for logs.

All of my SQL references arcs as the owner of the tables.

I have a login name of arcs.

When I create the database should I use the login of arcs
as owner? If I do this, I cannot seem to add arcs as a
user, this causes my SQL to fail, as it references all
tables using the owner name of arcs.

I used the name ARCS_NIMO for the database. If I run
multiple client databases I figure I can go with a name
of ARCS_<client name>. Is this a good plan?

Any information on best practices for setting up the
server, and hardware would be appreciated.

Thanks,

Jon Greisz
Development Manager
DB Microware, Inc.


Eoin Woods (Sybase UK) Posted on 1998-03-30 13:07:16.0Z
Message-ID: <351F9904.442E2AD3@sybase.com>
Date: Mon, 30 Mar 1998 14:07:16 +0100
From: "Eoin Woods (Sybase UK)" <eoin.woods@sybase.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Jon Greisz <jgg@dbmicro.com>
Subject: Re: setting up Sybase, converting from Oracle
References: <MPG.f8572b2463b4d8298968e@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5092
Article PK: 1092456


> I'v installed and setup a couple of devices, one for
> data, one for logs.

OK so far (typically you have each device dedicated to 1 database,
but that isn't critical).

> All of my SQL references arcs as the owner of the tables.
This isn't typically the way it is done in ASE, but it can be
(usually all objects are owned by the "dbo" user - database owner -
who then grants access to others).

> I have a login name of arcs.
OK.

> When I create the database should I use the login of arcs
> as owner? If I do this, I cannot seem to add arcs as a
> user, this causes my SQL to fail, as it references all
> tables using the owner name of arcs.
You probably want to leave 'sa' owning the database. Then arcs can
be added as a database user. If login arcs owns the database, then
whenever they use the database they are user "dbo". This is the
normal ASE setup approach. However if all your SQL presumes a user
name of "arcs" it would be simpler to have "arcs" as a login and
as a database user.

> I used the name ARCS_NIMO for the database. If I run
> multiple client databases I figure I can go with a name
> of ARCS_<client name>. Is this a good plan?
That seems fine.

Eoin.
--
Eoin Woods, NT Development, ASE Engineering, Sybase Inc.
Sybase (UK), Crown Lane, Maidenhead, Berkshire, SL6 8QZ
Tel: +44-1628-597215 Fax: +44-1628-597000
Email: Eoin.Woods@sybase.com