>Instead of scripting, wouldn't it be easier to detach or take offline from source and attach at target?
>I use it to carry the db between work and home computer (provided it's not huge for carrying on USB stick or something like that).
>-Detach
>-Zip data files
>-Attach
>
>On target:
>-Unzip
>-Attach
>
>Instead of scripting SQL server itself use this one or data as csv files to bulk load on target via a script. You may check SQL2008 CTP sample databases from codeplex.
>
>Cetin
Thanks a lot, Cetin. I may detach/attach the next time.
If it's not broken, fix it until it is.
My Blog