Transfer SQL Server Objects Task - Change Schema - SQL 2005

Not sure exactly what you want to accomplish, but you can transfer over the
db's minus the login info. Under the copy tab on the "Copy Sql Server Object
Task properties" you can de-select the "copy all objects" option. Then select
the "select objects..." button, and as the name suggests, pick exactly what
you want to transfer.

Note this is in sql 2000. I don't know how 2005 is setup. Hope this is what
you had in mind.

Dre

"nojetlag" wrote:

> Hi there,
>
> I have a development server where I have tables that are bound to the
> dbo schema, I tried to use the "Transfer SQL Server Objects Task" to
> transfer these tables to my hosting providers SQL 2005 server. However
> for obvious reasons I'm not dbo over there. So when I select the tables
> he tries to copy dbo.xxxxxx and can't create them on the hosting
> server. Is there a way in the task to change the schema on the fly ?
>
> best regards
> andreas
>
>
 >> Stay informed about: Transfer SQL Server Objects Task - Change Schema - SQL 2005 

Sorry my mistake. Under the copy tab on the "Copy Sql Server Object Task
properties", ensure that the "Use default option" is checked then click on
the options button. A new window will pop up. Clear those first 3 options
under security and that should do it.

dre

> Task properties"

"Andre Gibson" wrote:

> Not sure exactly what you want to accomplish, but you can transfer over the
> db's minus the login info. Under the copy tab on the "Copy Sql Server Object
> Task properties" you can de-select the "copy all objects" option. Then select
> the "select objects..." button, and as the name suggests, pick exactly what
> you want to transfer.
>
> Note this is in sql 2000. I don't know how 2005 is setup. Hope this is what
> you had in mind.
>
> Dre
>
> "nojetlag" wrote:
>
> > Hi there,
> >
> > I have a development server where I have tables that are bound to the
> > dbo schema, I tried to use the "Transfer SQL Server Objects Task" to
> > transfer these tables to my hosting providers SQL 2005 server. However
> > for obvious reasons I'm not dbo over there. So when I select the tables
> > he tries to copy dbo.xxxxxx and can't create them on the hosting
> > server. Is there a way in the task to change the schema on the fly ?
> >
> > best regards
> > andreas
> >
> >
 >> Stay informed about: Transfer SQL Server Objects Task - Change Schema - SQL 2005