Re: Import Data succeeds but doesn't copy data?

Tech-Archive recommends: Fix windows errors by optimizing your registry

<egg-on-face>

I went back to the import data script and looked at it carefully, and I
realized that the tables were being copied, but under a different schema,
so I ended up with a duplicate set of tables that DID have the data in
them :(

</egg-on-face>

My question is, is there any way to alter the schema identity of a table?

IOW: the application is looking for a table with a schema of "dbo" like:

[mydatabase].[dbo].[mytable]

but when I'm copying the database, the tables are being created as:

[mydatabase].[myschema].[mytable]

is there any way to "map" those tables with [myschema] to [dbo]? If I run
the app's script to create the tables, it creates them under [dbo], and if
I try to copy directly to those tables, all SSMS will let me do is create
new tables under schema [myschema]...help?

I figured it out <whew> ... changing the schema table-by-table fixed the
problem.


.

Relevant Pages

  • Re: Import Data succeeds but doesnt copy data?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... I went back to the import data script and looked at it carefully, ... is there any way to alter the schema identity of a table? ...
    (microsoft.public.sqlserver.tools)
  • Re: Access 2007, SQL 2000
    ... Since users are not dbo, and SQL 2000 used the user name as the schema identifier, you have to make sure that every reference to a SQL Server object is fully qualified with the dbo. ... Normally a user should not be able to create any new objects in the db, but if they do, those new objects will be in the userName schema, not the dbo schema, assuming the user is not a db owner. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: exporting into a SQL Server schema
    ... inside of the schema. ... The thing that's most confusing is that the dbo schema isn't ... take a look at the way the objects in the AdventureWorks database are ... It turns out that I'm moving some tables to a web hosted solution with sql ...
    (microsoft.public.access.externaldata)
  • Re: Database connection issue using SQL schema user account
    ... They can simplify permissions insofar as being able to have ... new objects created inside of a schema inherit permissions assigned to ... --The dbo user account is not the same thing as the dbo default ... The dbo user maps to db_owner/sysadmin. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Alter User for domain user
    ... connect to the server with Windows Authentication, the default schema ... (I used to have the dbo role, ... role on the server. ... schema different from dbo for a Windows login. ...
    (microsoft.public.sqlserver.security)