Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-24 : 07:48:12
|
| Dilip writes "HiI 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. exceptionERROR : 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 idofInterfaceWithError={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 errorRegardsDilip " |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-10-24 : 09:50:12
|
| OK, what's SMO?Also, I wonder if you can just do a restore....man I really have to get 2l5 up and runningBUT, short of that, I would script the database, bcp out all of the data, execute the script of 2k5, then bcp (or whatever the new program is) the data in.You also need to understand that there may be benfits of doing things differently in 2k5, so you might want to re-architect some thingsBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
|
|
|
Problem with Transfer in SMO