[DUG] MSSQL and Schemas

[Kyley Harris]

On an existing database?  No idea. If your tables and everything are
on the schema you probably need to export a script of all schema
content. Rename the schema and execute the script to rebuild
everything

then write a script of insert into selects to clone all the data

On Wednesday, July 14, 2010, Sandeep Chandra <sandeep_groups at yahoo.com> wrote:
> I have had enough with schema thing, I would like to drop this schema and
> transfer objects for this schema to the default schema. Could anyone please tell
> me how to do this?
>
> Regards
>
> Sandeep
>
>
>
> ----- Original Message ----
> From: Kyley Harris <Kyley at harrissoftware.com>
> To: NZ Borland Developers Group - Delphi List <delphi at delphi.org.nz>
> Sent: Mon, 12 July, 2010 5:12:42 PM
> Subject: Re: [DUG] MSSQL and Schemas
>
> Each user on the database can have a default database they log into..
> on each database you can also set the default Schema that its used by
> the login when accessing the database..
>
> by default its dbo.. when its dbo, you must explicitly prefix any
> other schema by name.. there is a routine you can call to change the
> default schema for each user on the database.
>
> On Mon, Jul 12, 2010 at 4:52 PM, Stephen Barker <Steve at webdata.co.nz> wrote:
>> Hi Sandeep,
>>
>> I don't use MSSQL, but I did have to do a job with it a few years back and
>> got caught out with the customer's db being set to case sensitive which
>> affected all objects - just a thought,
>>
>> Steve
>>
>>> -----Original Message-----
>>> From: Sandeep Chandra [mailto:sandeep_groups at yahoo.com]
>>> Sent: Sunday, 11 July 2010 12:28 a.m.
>>> To: NZ Borland Developers Group - Delphi List
>>> Subject: [DUG] MSSQL and Schemas
>>>
>>> Hi
>>>
>>> I have got a MSSQL(2005)  database that has objects in a
>>> schema. Things work
>>> fine on development machine but when I try to put the
>>> database on another
>>> machine I am not able to run the stored procedures belonging
>>> to the schema.
>>>
>>> On Development machine I have a stored procedure
>>> MySchema.MyStorProc and it is
>>> running fine without me adding schema name to exec command
>>> (exec MyStorProc).
>>> If I run the same command on another machine I get error
>>> saying "Could not find
>>> stored procedure MyStorProc" but if I exec it like "exec
>>> MySchema.MyStorProc"
>>> then it runs fine.
>>>
>>> I don't know much about schema's other than that they are
>>> like namespaces.
>>>
>>> Not sure what I should do to resolve this issue as I don't
>>> want to change the
>>> source code to include the schema name in front of all the
>>> stored procedure
>>> calls, any help would be highly appreciated.
>>>
>>> Regards
>>>
>>> Sandeep
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> NZ Borland Developers Group - Delphi mailing list
>>> Post: delphi at delphi.org.nz
>>> Admin: http://delphi.org.nz/mailman/listinfo/delphi
>>> Unsubscribe: send an email to delphi-request at delphi.org.nz
>>> with Subject: unsubscribe
>>> No virus found in this incoming message.
>>> Checked by AVG - www.avg.com
>>> Version: 9.0.830 / Virus Database: 271.1.1/2939 - Release
>>> Date: 07/10/10 18:36:00
>>>
>>>
>> _______________________________________________
>> NZ Borland Developers Group - Delphi mailing list
>> Post: delphi at delphi.org.nz
>> Admin: http://delphi.org.nz/mailman/listinfo/delphi
>> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
>>unsubscribe
>>
>
>
>
> --
> Kyley Harris
> Harris Software
> +64-21-671-821
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> unsubscribe
>
>
>
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin:  <http://delphi.org.nz/mailman/listinfo/delphi>

-- 
Kyley Harris
Harris Software
+64-21-671-821