Transfer SQL Server Objects Task doesn't work with schemas

Transfer SQL Server Objects Task doesn't work with schemas

• Talljames

  Actually the transfer is between a SQL2005 and SQL2005 database!
  

• Ed Tenholder

  I think the prob is that it doesn't look for the schema.

  I i want to copy a table with schema [Test]

  like: [test].table1

  the error says

  "Table "table1" does not exist at the source."

  Therefore it seem like it's looking for table1 without schemas.

  So if i create a table without schemas called table1, it's actually this table that it copies, and not the one that i selected.

  
  

• Martin.Cruz

  Just confirming what you already know and putting my vote in for this to be fixed.

  It seems to only work if the login to SQL you are using has the default schema the same as the object you're trying to copy. So if you use sa you can probably copy all object in the dbo schema. Hopefully this will get fixed soon. Also would be great if you could rename the destination table for transfer of objects within the same db.

  
  

• maxim4o

  Why isn't this issue yet fixed in SP2
  
  

• VB king!

  If you are trying to transfer objects from SQL Server 2000 to SQL Server 2005, then this error message is due to a known bug. We are considering to fix that bug in the next release.
  
  
  

• Gabe Frost - MSFT

  Thanks :-)
  
• Transfer SQL Server Objects Task doesn't work with schemas