Hi,

I am using DBGhost to deploy any db structures changes and SP changes to
my client. It is compatible with SQL2005 too. Maybe you can look
at www.dbghost.com for more details.



>>Detach it, make copies of the files and attach on the destination server.
>I did sp_detach_db/sp_attach_db. Worked fine.
>
>>Script data structures and data and run scripts on the destination server.
>How do I script data structures? Is there something similar to Foxpro's GenDBC?