Move database file: easiest

Showing posts with label easiest. Show all posts

Monday, March 26, 2012

Moving a database from SQL Server to MSDE

Hi,
I have created quite a large database project that the client now wants to
run locally for demo purposes.
What is the best (& easiest for non-programmer client) way to transport a
snapshot of this database from one to the other - with the data still
intact? The VS.Net tools appear to only move the structure and stored
procedures etc..
Thanks in adavance,
StuStu
I prefer BACKUP/RESTORE commands
"Stu Lock" <s.lock@.cergis.com> wrote in message
news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have created quite a large database project that the client now wants to
> run locally for demo purposes.
> What is the best (& easiest for non-programmer client) way to transport a
> snapshot of this database from one to the other - with the data still
> intact? The VS.Net tools appear to only move the structure and stored
> procedures etc..
> Thanks in adavance,
> Stu
>|||How do you restore an SQL Server database to an MSDE instance that has no
database installed?
THnx.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23B1asKyyEHA.3840@.tk2msftngp13.phx.gbl...
> Stu
> I prefer BACKUP/RESTORE commands
>
>
> "Stu Lock" <s.lock@.cergis.com> wrote in message
> news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> I have created quite a large database project that the client now wants
>> to
>> run locally for demo purposes.
>> What is the best (& easiest for non-programmer client) way to transport a
>> snapshot of this database from one to the other - with the data still
>> intact? The VS.Net tools appear to only move the structure and stored
>> procedures etc..
>> Thanks in adavance,
>> Stu
>>
>|||"Stu Lock" <s.lock@.cergis.com> wrote in message
news:%23gQ5rBzyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> How do you restore an SQL Server database to an MSDE instance that has no
> database installed?
>
Same way you'd restore it to any SQL Server. RESTORE DATABASE foo from
disk='\\foo\bar\baz.bak'
BOL will have more details.
> THnx.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23B1asKyyEHA.3840@.tk2msftngp13.phx.gbl...
> > Stu
> > I prefer BACKUP/RESTORE commands
> >
> >
> >
> >
> > "Stu Lock" <s.lock@.cergis.com> wrote in message
> > news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
> >> Hi,
> >>
> >> I have created quite a large database project that the client now wants
> >> to
> >> run locally for demo purposes.
> >>
> >> What is the best (& easiest for non-programmer client) way to transport
a
> >> snapshot of this database from one to the other - with the data still
> >> intact? The VS.Net tools appear to only move the structure and stored
> >> procedures etc..
> >>
> >> Thanks in adavance,
> >>
> >> Stu
> >>
> >>
> >
> >
>|||Just be aware of the limitations of MSDE. Maximum DB size is 2GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:DVbmd.8248$qv5.8175@.twister.nyroc.rr.com...
> "Stu Lock" <s.lock@.cergis.com> wrote in message
> news:%23gQ5rBzyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> > How do you restore an SQL Server database to an MSDE instance that has
no
> > database installed?
> >
> Same way you'd restore it to any SQL Server. RESTORE DATABASE foo from
> disk='\\foo\bar\baz.bak'
> BOL will have more details.
>
> > THnx.
> >
> >
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:%23B1asKyyEHA.3840@.tk2msftngp13.phx.gbl...
> > > Stu
> > > I prefer BACKUP/RESTORE commands
> > >
> > >
> > >
> > >
> > > "Stu Lock" <s.lock@.cergis.com> wrote in message
> > > news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
> > >> Hi,
> > >>
> > >> I have created quite a large database project that the client now
wants
> > >> to
> > >> run locally for demo purposes.
> > >>
> > >> What is the best (& easiest for non-programmer client) way to
transport
> a
> > >> snapshot of this database from one to the other - with the data still
> > >> intact? The VS.Net tools appear to only move the structure and stored
> > >> procedures etc..
> > >>
> > >> Thanks in adavance,
> > >>
> > >> Stu
> > >>
> > >>
> > >
> > >
> >
> >
>

Moving a database from SQL Server to MSDE

Moving a Database

I have a few databases that is clogging up my C drive and I would like to
move them to my D: drive.
What is the easiest and safest way to do that?Hi,
just
-detach them from drive c:
-copy over to drive d:
-attach on drive d:
You can either use thhe GUi for attach /detach or use the sp_detach /
sp_attach statement / procedure for that, more details can be found in
the BOL.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--|||Cool, thank you.
But where is the GUI located for that?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
depends on which version of SQL Server you are using. If you use the
client tools for SQL 2000 you lopen the enterprise manager, navigate to
the database you want to detach, right click, select detach, copy the
files, right click on the Server, select attach, browse to the
destination and you are done.
It is nearly the same for SQl Server Management Studio and SQl Server
2005.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||How or where do I find teh GUI?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||You didn=B4t say yet which version of SQL Server you are using.sql

Moving a Database

I have a few databases that is clogging up my C drive and I would like to
move them to my D: drive.
What is the easiest and safest way to do that?Hi,
just
-detach them from drive c:
-copy over to drive d:
-attach on drive d:
You can either use thhe GUi for attach /detach or use the sp_detach /
sp_attach statement / procedure for that, more details can be found in
the BOL.
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Cool, thank you.
But where is the GUI located for that?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
depends on which version of SQL Server you are using. If you use the
client tools for SQL 2000 you lopen the enterprise manager, navigate to
the database you want to detach, right click, select detach, copy the
files, right click on the Server, select attach, browse to the
destination and you are done.
It is nearly the same for SQl Server Management Studio and SQl Server
2005.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||How or where do I find teh GUI?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||You didn=B4t say yet which version of SQL Server you are using.

Monday, March 12, 2012

Move Sql 7 databases to SQL 2000 server on different network

What would be the best/easiest procedure to move a few SQL 7 databases to a
SQL 2000 server that is running on a different network?It's easy enough to back them up, copy the backup files to
the SQL2000 server, and restore there.
If you have reliable network connectivity, you could skip
the copy step and restore directly from the backup files
on the remote server by specifying the files' UNC names.
You could also backup to the remote server, and then
restore from the backup files locally on the other server.
Linchi
>--Original Message--
>What would be the best/easiest procedure to move a few
SQL 7 databases to a
>SQL 2000 server that is running on a different network?
>
>.
>|||| What would be the best/easiest procedure to move a few SQL 7 databases to
a
| SQL 2000 server that is running on a different network?
--
I would backup the SQL 7 database, ship the backup file to the SQL 2000
server and restore it there.
Hope this help,s
--
Eric Cárdenas
SQL Server support|||>--Original Message--
>| What would be the best/easiest procedure to move a few
SQL 7 databases to
>a
>| SQL 2000 server that is running on a different network?
>--
>I would backup the SQL 7 database, ship the backup file
to the SQL 2000
>server and restore it there.
Make sure that both servers are using the same settings
for Locale, Collation and case sensitivity.
Dave.|||> Make sure that both servers are using the same settings
> for Locale, Collation and case sensitivity.
Just to expand a bit:
They don't *have* to be on the same collation setting as in SQL2K, you can have different collations
between different databases. However, that might cause problems if the code isn't written to handle
this, so I agree that this is a good idea.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:06fe01c3c3b9$aa8a1cd0$a501280a@.phx.gbl...
> >--Original Message--
> >| What would be the best/easiest procedure to move a few
> SQL 7 databases to
> >a
> >| SQL 2000 server that is running on a different network?
> >--
> >I would backup the SQL 7 database, ship the backup file
> to the SQL 2000
> >server and restore it there.
> Make sure that both servers are using the same settings
> for Locale, Collation and case sensitivity.
> Dave.

Friday, March 9, 2012

move objects between mdf files

what is the easiest way to move objects (tables with data and stored procedures) from one sqlexpress database mdf to another mdf?

You can use SELECT...INTO as documented at http://msdn2.microsoft.com/en-us/library/ms190750.aspx. Just identify your table using four part naming so that you can direct it to the table in the other database.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

Move logins with passwords

Hello!
I will reinstall my server who has SQL server 2000, containing a few
databases with logins.
Which is the easiest way to store these on disk and when I have reinstalled
my server, add these to SQL again, hopefully containing passwords as well.
Regards Magnushttp://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
"MB" <magnus.blomberg@.skanska.se> wrote in message
news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> Hello!
> I will reinstall my server who has SQL server 2000, containing a few
> databases with logins.
> Which is the easiest way to store these on disk and when I have
reinstalled
> my server, add these to SQL again, hopefully containing passwords as well.
> Regards Magnus
>|||Thank you. It helped
Regards Magnus
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OtBdL4w9DHA.1636@.TK2MSFTNGP12.phx.gbl...
> 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
>
> "MB" <magnus.blomberg@.skanska.se> wrote in message
> news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> reinstalled
well.
>

Monday, February 20, 2012

Move database

Hello,

What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures?

Thanks,

For just the structure (not the data) you can create a create script for the database (in enterprise Manager, right click any object in the database and Generate SQL Script should be an option).

For everything, including data, you can detatch the database, move the physical database file, and then attach the database file in the new location.

DTS will also allow you to move data and tables.

|||Would Backup?Restore work for this?|||to restore structure and data, yes.

Monday, March 26, 2012

Moving a database from SQL Server to MSDE

Moving a database from SQL Server to MSDE

Moving a database from SQL Server to MSDE

Moving a Database

Moving a Database

Monday, March 12, 2012

Move Sql 7 databases to SQL 2000 server on different network

Friday, March 9, 2012

move objects between mdf files

Move logins with passwords

Monday, February 20, 2012

Move database

Move database file

Blog Archive

About Me