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 |
|
blakmk
Starting Member
45 Posts |
 Posted - 2006-11-17 : 05:59:45
|
| Having used the scptxfr utility successfully on Sql 2000, I am trying to use it against sql 2005. I have had mixed results, in simple databases this seems to work ok however in complex databases the utility appears to hang, has any one had this problem or knows of a workaround? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-17 : 11:35:51
|
| scptxfr wasn't released with 2005 so it will not work with any of the new features of 2005. You should use a 2005 tool with 2005 databases, either script the database in SSMS, or use SSIS, or write your own custom code with SMO. |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-17 : 16:55:02
|
| Another optionhttp://sqlteam.com/forums/topic.asp?TOPIC_ID=73608 |
|
|
|
|
|
|
scptxfr problems on sql 2005