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,I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
--
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.googlegroups.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,
>|||... 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.googlegroups.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,
>|||Hi Steve,
Just make a backup (using the SQL Server backup engine) of the
Vista-based database to a network share on your W2K3 server then restore
that backup on the W2K3 machine. This should look something as follows:
--On the Vista PC
backup database mydb
to disk = '\\w2k3server\myshare\mydb.bak'
--On the W2K3 Server
restore database mydb
from disk = 'c:\mysharedfolder\mydb.bak'
Hope this helps!
Jonathan
Steve Richter wrote:
> 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,
>|||On Jul 19, 5:00 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
>
gosh, that was easy. The only thing I add knowledge wise is I had to
first install the sql server managment studio express on my Vista PC.
thanks,
-Steve