Copy db from office to home back to office

Hello. I am developing an SQL database using MSDE and will be doing
development at the client's office as well as my home office. I need to be
able to take the database back and forth. What are my options for
accomplishing this task? Note that I am new to SQL so as usual, one
question will likely spawn more. I am very familiar with MS Access.
Thanks
GerryIf you are the only developer, and the db size is small enough, use
SP_detach_db and sp_attach_db to make it portable, and copy the .mdf and
.ldf files to a flash drive.
I use this technique myself. For a different client, the only thing I do
differntly is use FTP instead of a flash drive (have a sub-contractor
working that one...)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"News" <gerrydyck@.shaw.ca> wrote in message
news:9bTTb.398008$ts4.256106@.pd7tw3no...
> Hello. I am developing an SQL database using MSDE and will be doing
> development at the client's office as well as my home office. I need to
be
> able to take the database back and forth. What are my options for
> accomplishing this task? Note that I am new to SQL so as usual, one
> question will likely spawn more. I am very familiar with MS Access.
> Thanks
> Gerry
>|||These should help:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly
SQL Server MVP
"News" <gerrydyck@.shaw.ca> wrote in message
news:9bTTb.398008$ts4.256106@.pd7tw3no...
> Hello. I am developing an SQL database using MSDE and will be doing
> development at the client's office as well as my home office. I need to
be
> able to take the database back and forth. What are my options for
> accomplishing this task? Note that I am new to SQL so as usual, one
> question will likely spawn more. I am very familiar with MS Access.
> Thanks
> Gerry
>|||Thanks Kevin and Andrew (next reply) for such a quick response.
Now the questions continue as suspected. LOL
Using MSDE, how do I use SP_detach_db and sp_attach_db? It seems that these
commands are easily done in SQL Server 2000 but I don't have the interface.
Is there a dos command to do the same?
Thanks
Gerry
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:uAQMkLp6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> If you are the only developer, and the db size is small enough, use
> SP_detach_db and sp_attach_db to make it portable, and copy the .mdf and
> .ldf files to a flash drive.
> I use this technique myself. For a different client, the only thing I do
> differntly is use FTP instead of a flash drive (have a sub-contractor
> working that one...)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "News" <gerrydyck@.shaw.ca> wrote in message
> news:9bTTb.398008$ts4.256106@.pd7tw3no...
> > Hello. I am developing an SQL database using MSDE and will be doing
> > development at the client's office as well as my home office. I need to
> be
> > able to take the database back and forth. What are my options for
> > accomplishing this task? Note that I am new to SQL so as usual, one
> > question will likely spawn more. I am very familiar with MS Access.
> >
> > Thanks
> > Gerry
> >
> >
>|||You should still have oSql. Check out oSql.exe in BooksOnLine.
--
Andrew J. Kelly
SQL Server MVP
"News" <gerrydyck@.shaw.ca> wrote in message
news:KPTTb.398535$ts4.141111@.pd7tw3no...
> Thanks Kevin and Andrew (next reply) for such a quick response.
> Now the questions continue as suspected. LOL
> Using MSDE, how do I use SP_detach_db and sp_attach_db? It seems that
these
> commands are easily done in SQL Server 2000 but I don't have the
interface.
> Is there a dos command to do the same?
> Thanks
> Gerry
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:uAQMkLp6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > If you are the only developer, and the db size is small enough, use
> > SP_detach_db and sp_attach_db to make it portable, and copy the .mdf and
> > .ldf files to a flash drive.
> >
> > I use this technique myself. For a different client, the only thing I
do
> > differntly is use FTP instead of a flash drive (have a sub-contractor
> > working that one...)
> >
> > --
> > Kevin Hill
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> >
> > "News" <gerrydyck@.shaw.ca> wrote in message
> > news:9bTTb.398008$ts4.256106@.pd7tw3no...
> > > Hello. I am developing an SQL database using MSDE and will be doing
> > > development at the client's office as well as my home office. I need
to
> > be
> > > able to take the database back and forth. What are my options for
> > > accomplishing this task? Note that I am new to SQL so as usual, one
> > > question will likely spawn more. I am very familiar with MS Access.
> > >
> > > Thanks
> > > Gerry
> > >
> > >
> >
> >
>