MS SQL Server - Problem with Transfer in SMO

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

Problem with Transfer in SMO

dvarma

2006-10-24, 6:38 pm

Hi
I am trying to transfer a Sql 2000 db to a Sql 2005 db . I use Transfer
class of SMO
for this.

I want to copy the entire db.

When I finally do trans.Transfer()
I get the foll. exception

ERROR : errorCode=-1071636471 description=An OLE DB error has occurred.
Error code: 0x800400FA.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x800400FA Description: "All bound columns are read-only".
helpFile=dtsmsg.rll helpContext=0
idofInterfaceWithErr
or={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

I find that the tables with data + SP + UDF have been transferred but the
users , triggers, keys and constraints have not. Perhaps the exception was
thrown before SMO could do this.

Please help me resolve this error

Regards
Dilip

Sponsored Links