Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?

Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?
Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?
sql

Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?

Exporting from MSDE to SQL Server

Hi All,

I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.

I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.

Is there an easy wy to go about this?

- Mina

I would install SQL Server backup your databases and restore it in SQL Server with same name if you use the restore from Device option in the backup wizard and SQL Server will move everything for you including permissions. Then moving to the host provider will be easy because SQL Sever Enterprise Manager is needed to move your databases with most Host Companies. Hope this helps.|||You need to talk to your hosting provider -- the easiest way toaccomplish this will be to simply send them the detached MDF and LDFfiles and have the provider attach them. Whether or not they'rewilling to do that is another question

Exporting from MSDE 2000 to SQL Server 2003 DB

I originally posted

http://forums.microsoft.com/msdn/ShowPost.aspx?postid=900493&SiteID=1

How would I move a db in MSDE 2000 to SQL server 2003. I want to
include the db structure and data.

The MSDE and SQL Server system use the same file structure to store the information, the only difference is the engine. To move the MSDE Database to a full server install is as easy as backing up the database and restoreing it on the server install. This will work when transfering from MSDE 2000 to SQL Server 2005 (All Editions).

Remember if you need some management tools you can get the SQL Management Studio for SQL Server Express and connect to the database to assist in performing the tasks, or if you have the full SQL Server 2005 Install you can also use the Management SStudio that was installed with that.

The Express Management tools can be downloaded for free from the Microsoft Downloads Site.

|||A lot of options: backup/restore, attach/detach or ALTER DATABASE with MOVE option

exporting desktop MSDE to remote server Sql

What is the best tool for doing this? I have been using MSDE to create a
portal app on my desktop and now want to move the data from the MSDE db
locally to the remote server db. I can export the MSDE data but need a way
to get it to the remote sever and import it. Enterprise Manager seems to
be the tool of choice for this but I don't have it so I need another way.
Thanks!
Try WinSQL at http://www.synametrics.com/winsql. I have found to be the
best solution if Enterprise Manager is not available. It can move the
data as well as serve as a query tool.
Regards,
PM
Bob K. wrote:

> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a way
> to get it to the remote sever and import it. Enterprise Manager seems to
> be the tool of choice for this but I don't have it so I need another way.
> Thanks!
>
|||hi Bob,
"Bob K." <bob1030@.hotmail.com> ha scritto nel messaggio
news:A2YLc.6720$eM2.877@.attbi_s51...
> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a
way
> to get it to the remote sever and import it. Enterprise Manager seems
to
> be the tool of choice for this but I don't have it so I need another way.
you can have a look at Web Data Administrator,
http://www.microsoft.com/downloads/d...displaylang=en
which implements a Web interface where you can execute Transact-SQL scripts
and/or (partially) manage your databases...
other tools, both free and commercial can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442 ..
you can have a look at a free prj of mine too, available at the link
following my sign..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Export SQL Database to MSDE [WP]

I know this may sound silly.
I want to export a small DB from my SQL2000 to an MSDE.
Advise Please as to how can I do this?
Thank youHi,
Like export just the data or move the entire structure? I'm assuming you
are referring to the latter . . thus
1. You could DETACH/ATTACH the database from SQL2000 to MSDE.
2. You could use DTS to migrate the database to MSDE. This would also work
if you need to just move the data.
3. You could use the BACKUP/RESTORE method as well.
Hope this helps . .
~John
"WILDPACKET" wrote:
> I know this may sound silly.
> I want to export a small DB from my SQL2000 to an MSDE.
> Advise Please as to how can I do this?
> Thank you|||John,
Thank you for your response.
I am new to this whole MSDE/SQL thing.
This is a blackberry DB 180MB which I have to move from the SQL2000 server
to another server running MSDE.
"FireDBA" wrote:
> Hi,
> Like export just the data or move the entire structure? I'm assuming you
> are referring to the latter . . thus
> 1. You could DETACH/ATTACH the database from SQL2000 to MSDE.
> 2. You could use DTS to migrate the database to MSDE. This would also work
> if you need to just move the data.
> 3. You could use the BACKUP/RESTORE method as well.
> Hope this helps . .
> ~John
> "WILDPACKET" wrote:
> >
> > I know this may sound silly.
> >
> > I want to export a small DB from my SQL2000 to an MSDE.
> >
> > Advise Please as to how can I do this?
> >
> > Thank you|||Your very welcome.
The backup/restore option will probably be the easiest to accomplish.
I'm sure that you can find reference to using backup/restore online or via
Books OnLine. The Books Online will be your best friend as you progress
through the world of SQL! =)
SQL 2000 BOL URL
http://msdn2.microsoft.com/en-us/library/ms950404.aspx
Hope this helps!
~John
"WILDPACKET" wrote:
> John,
> Thank you for your response.
> I am new to this whole MSDE/SQL thing.
> This is a blackberry DB 180MB which I have to move from the SQL2000 server
> to another server running MSDE.
>
>
> "FireDBA" wrote:
> > Hi,
> >
> > Like export just the data or move the entire structure? I'm assuming you
> > are referring to the latter . . thus
> >
> > 1. You could DETACH/ATTACH the database from SQL2000 to MSDE.
> > 2. You could use DTS to migrate the database to MSDE. This would also work
> > if you need to just move the data.
> > 3. You could use the BACKUP/RESTORE method as well.
> >
> > Hope this helps . .
> >
> > ~John
> >
> > "WILDPACKET" wrote:
> >
> > >
> > > I know this may sound silly.
> > >
> > > I want to export a small DB from my SQL2000 to an MSDE.
> > >
> > > Advise Please as to how can I do this?
> > >
> > > Thank you|||You also need to make sure that the correct user accounts exist on the
target server where you will be moving this database
"WILDPACKET" <WILDPACKET@.discussions.microsoft.com> wrote in message
news:E03C6C4E-B3B4-4119-97ED-87E1CE066399@.microsoft.com...
> John,
> Thank you for your response.
> I am new to this whole MSDE/SQL thing.
> This is a blackberry DB 180MB which I have to move from the SQL2000 server
> to another server running MSDE.
>
>
> "FireDBA" wrote:
>> Hi,
>> Like export just the data or move the entire structure? I'm assuming you
>> are referring to the latter . . thus
>> 1. You could DETACH/ATTACH the database from SQL2000 to MSDE.
>> 2. You could use DTS to migrate the database to MSDE. This would also
>> work
>> if you need to just move the data.
>> 3. You could use the BACKUP/RESTORE method as well.
>> Hope this helps . .
>> ~John
>> "WILDPACKET" wrote:
>> >
>> > I know this may sound silly.
>> >
>> > I want to export a small DB from my SQL2000 to an MSDE.
>> >
>> > Advise Please as to how can I do this?
>> >
>> > Thank you|||Bass
Pls, look at my posting above to see if you can help me out.
Regards
Henrik Arenblad, MCP-SBS,
"bass_player [SBS-MVP]" <bass_player@.mvps.org> wrote in message
news:%23dTkWWxCIHA.2280@.TK2MSFTNGP02.phx.gbl...
> You also need to make sure that the correct user accounts exist on the
> target server where you will be moving this database
>
> "WILDPACKET" <WILDPACKET@.discussions.microsoft.com> wrote in message
> news:E03C6C4E-B3B4-4119-97ED-87E1CE066399@.microsoft.com...
>> John,
>> Thank you for your response.
>> I am new to this whole MSDE/SQL thing.
>> This is a blackberry DB 180MB which I have to move from the SQL2000
>> server
>> to another server running MSDE.
>>
>>
>> "FireDBA" wrote:
>> Hi,
>> Like export just the data or move the entire structure? I'm assuming
>> you
>> are referring to the latter . . thus
>> 1. You could DETACH/ATTACH the database from SQL2000 to MSDE.
>> 2. You could use DTS to migrate the database to MSDE. This would also
>> work
>> if you need to just move the data.
>> 3. You could use the BACKUP/RESTORE method as well.
>> Hope this helps . .
>> ~John
>> "WILDPACKET" wrote:
>> >
>> > I know this may sound silly.
>> >
>> > I want to export a small DB from my SQL2000 to an MSDE.
>> >
>> > Advise Please as to how can I do this?
>> >
>> > Thank you
>