|
Home > Archive > MS SQL Server DTS > January 2006 > Transfer SQL Server Objects Task - Change Schema - SQL 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transfer SQL Server Objects Task - Change Schema - SQL 2005
|
|
| nojetlag 2006-01-27, 8:24 pm |
| 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
| |
| nojetlag 2006-01-27, 8:24 pm |
| Well let me add that the specific error message I get is
Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL
Server Objects Task: Execution failed with the following error: "Cannot
apply value null to property Login: Value cannot be null..".
Task failed: Transfer SQL Server Objects Task
However somehow I assume it is related to the schema
| |
| Andre Gibson 2006-01-27, 8:24 pm |
| 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
>
>
| |
| Andre Gibson 2006-01-27, 8:24 pm |
| 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:
[color=darkred]
> 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:
>
|
|
|
|
|