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
> > >
> > >
> >
> >
>
Showing posts with label home. Show all posts
Showing posts with label home. Show all posts
Sunday, March 25, 2012
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...
be
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/scr...sp?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...
be
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...
Andrew J. Kelly
SQL Server MVP
"News" <gerrydyck@.shaw.ca> wrote in message
news:KPTTb.398535$ts4.141111@.pd7tw3no...
these
interface.
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...
quote:
> 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
quote:|||These should help:
> 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
>
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/scr...sp?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...
quote:
> 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
quote:|||Thanks Kevin and Andrew (next reply) for such a quick response.
> 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
>
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...
quote:|||You should still have oSql. Check out oSql.exe in BooksOnLine.
> 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...
> be
>
Andrew J. Kelly
SQL Server MVP
"News" <gerrydyck@.shaw.ca> wrote in message
news:KPTTb.398535$ts4.141111@.pd7tw3no...
quote:
> 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
quote:
> commands are easily done in SQL Server 2000 but I don't have the
interface.
quote:
> 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...
do[QUOTE]
to[QUOTE]
>
Wednesday, March 7, 2012
Copy a view
Hi
At home i have sqlserver and at work we have sqlserver
At home i have make some views i also would like to use
on the server at work
To day i try to use import from my server to the server at work
but when i import my views the views become a table on the server at work
Is there a way to copy/import the views on from my server at home to the server at work
On my work can i connect to my server at home, so this is not the problem.
Or shall i make new views on the server at work?
Alvin
You could script the views to files (at home) and then take the scripted views to work, open them and execute and the views will get created on your work Server
In Server Management Studio, right click the view you want to script and choose
Script View >> as CREATE >> to File...
The file created will have an extension of .sql but it is a text file...
OR
If you can connect to your server from work, you can do the above, but change >> to File TO >> to New Query Editor Window and then you can cut/paste the script into your work server and execute to create the view...
|||
Thanks
Alvin
Subscribe to:
Posts (Atom)