Case Sensitive ?

We are going to migrate an Oracle Database to SQL Server
2000 by a contractor.
The data in the Oracle Database is case sensitive as it is
a legay system.
When we migrate to SQL Server 2000, we will use reporting
tools via ODBC connection to the database. We would like
to know can the new system be case insensitive during
query, especially during the wildcard search.
Thanks
What you want to read up on is "collations" in SQL Server. You define a collation at install, it
goes for the system databases, and is default for user databases. When you create a user db, you can
override system default. When you create a table, you can define collation for each column (default
is database default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:09f301c52aae$2afc96c0$a501280a@.phx.gbl...
> We are going to migrate an Oracle Database to SQL Server
> 2000 by a contractor.
> The data in the Oracle Database is case sensitive as it is
> a legay system.
> When we migrate to SQL Server 2000, we will use reporting
> tools via ODBC connection to the database. We would like
> to know can the new system be case insensitive during
> query, especially during the wildcard search.
> Thanks

Case Sensitive ?

We are going to migrate an Oracle Database to SQL Server
2000 by a contractor.
The data in the Oracle Database is case sensitive as it is
a legay system.
When we migrate to SQL Server 2000, we will use reporting
tools via ODBC connection to the database. We would like
to know can the new system be case insensitive during
query, especially during the wildcard search.
ThanksWhat you want to read up on is "collations" in SQL Server. You define a coll
ation at install, it
goes for the system databases, and is default for user databases. When you c
reate a user db, you can
override system default. When you create a table, you can define collation f
or each column (default
is database default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:09f301c52aae$2afc96c0$a501280a@.phx.gbl...
> We are going to migrate an Oracle Database to SQL Server
> 2000 by a contractor.
> The data in the Oracle Database is case sensitive as it is
> a legay system.
> When we migrate to SQL Server 2000, we will use reporting
> tools via ODBC connection to the database. We would like
> to know can the new system be case insensitive during
> query, especially during the wildcard search.
> Thanks

Capture existing table

I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
it. When I did, my database(DEV_DATA) remained intact, but when I go in
thru Enterprise Manager, it is not located in the system tree, and is
therefore inaccessible. Can anyone suggest how I could get this database
included.Have you tried attaching the database?

On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
<wfoneill@.bellsouth.net> wrote:

>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>thru Enterprise Manager, it is not located in the system tree, and is
>therefore inaccessible. Can anyone suggest how I could get this database
>included.|||Hi Steve:

Thank you for replying. Using EM, how would I attach, since I don't see my
database in the tree at all. All the other databases are there from the
installation, eg. Master, Tempdb, Northwind, etc.

"Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> Have you tried attaching the database?
> On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> <wfoneill@.bellsouth.net> wrote:
>>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>>thru Enterprise Manager, it is not located in the system tree, and is
>>therefore inaccessible. Can anyone suggest how I could get this database
>>included.
>|||"William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
> Hi Steve:
> Thank you for replying. Using EM, how would I attach, since I don't see
my
> database in the tree at all. All the other databases are there from the
> installation, eg. Master, Tempdb, Northwind, etc.

Best bet, don't use EM. Use query analyzer and use sp_attach_db

Otherwise, in EM on the machine in question, right click on databases and
select ALL TASKS and attach Database.

> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> > Have you tried attaching the database?
> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> > <wfoneill@.bellsouth.net> wrote:
> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
reinstall
> >>it. When I did, my database(DEV_DATA) remained intact, but when I go in
> >>thru Enterprise Manager, it is not located in the system tree, and is
> >>therefore inaccessible. Can anyone suggest how I could get this
database
> >>included.
> >>|||Thank you, Greg. Will give it a try!.

"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:f3c%c.13044$2s.12051@.twister.nyroc.rr.com...
> "William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
> news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
>> Hi Steve:
>>
>> Thank you for replying. Using EM, how would I attach, since I don't see
> my
>> database in the tree at all. All the other databases are there from the
>> installation, eg. Master, Tempdb, Northwind, etc.
>>
> Best bet, don't use EM. Use query analyzer and use sp_attach_db
> Otherwise, in EM on the machine in question, right click on databases and
> select ALL TASKS and attach Database.
>
>>
>> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
>> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
>> > Have you tried attaching the database?
>>> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
>> > <wfoneill@.bellsouth.net> wrote:
>>> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
> reinstall
>> >>it. When I did, my database(DEV_DATA) remained intact, but when I go
>> >>in
>> >>thru Enterprise Manager, it is not located in the system tree, and is
>> >>therefore inaccessible. Can anyone suggest how I could get this
> database
>> >>included.
>> >>
>>>
>>