how to copy sql server database

how do I go about copying a sql server database on my Vista
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,
... and if needed also bring the logins. Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegro ups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>