Hi Tom
If the objects are on source code control you may just want to check out the
scripts and run them through SQLCMD.
If you want the whole database then you can either use backup/restore or
sp_detach_db/sp_attach_db, failing that you could use the import/export
wizard, If SQLExpress is does not allow external connections then you will
need to push it (export) from the SQLExpress machine.
Check out
http://support.microsoft.com/kb/314546
John
"tlyczko" <tl*****@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Can anyone refer me to good 'recipes' or sources of information on this
topic??
I have Visual Studio Tools for Office, which installs SS 2005 Express
locally to my XP box, and I want to develop in SS 2005, then copy the
tables or queries or reports etc. to a SS 2005 Standard server.
Thank you, Tom