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
>