SQL .mdf file import.
How can i import a .mdf file(291MB in size) into a txt
file?
a step by step guide - as i know nothign about SQL 2000
thanks / Regards,
Jeff
Hi,
You can't import/export from a physical SQL server data file to a text file
or viceversa.
To do this first attach the MDF file as a database inside SQL server. After
that use the SQL server utilities BCP OUT or DTS to export the data from
tables to a Text file.
Thanks
Hari
MCDBA
"antz" <anonymous@.discussions.microsoft.com> wrote in message
news:58b501c42d31$6064e950$a001280a@.phx.gbl...
> SQL .mdf file import.
> How can i import a .mdf file(291MB in size) into a txt
> file?
> a step by step guide - as i know nothign about SQL 2000
> thanks / Regards,
> Jeff
|||thanks -
how do i go about attaching the mdf file?
to export it?
thanks
Jeff
>--Original Message--
>Hi,
>You can't import/export from a physical SQL server data
file to a text file
>or viceversa.
>To do this first attach the MDF file as a database
inside SQL server. After
>that use the SQL server utilities BCP OUT or DTS to
export the data from
>tables to a Text file.
>Thanks
>Hari
>MCDBA
>
>"antz" <anonymous@.discussions.microsoft.com> wrote in
message
>news:58b501c42d31$6064e950$a001280a@.phx.gbl...
>
>.
>
|||Hi Jeff,
Login to SQl server using the Query analyzer and try attaching the MDF file
as a database.
sp_attach_single_file_db
'dbname','physical_file_name_of_mdf_file_with_exac t_path'
Note:
Normally each database consists of 1 MDF and 1 LDF (Transactionlog) file. In
your case it seems you do not have the LDF file. So the above command may
file due to below reasons:-
1. If the database is not detached earlier
2. If the original database had more than 1 LDF files.
If your case does not fall in above categories then you will be able to
attach and then you can export contents to a text file using DTS or BCP.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:5a4a01c42d48$588653b0$a101280a@.phx.gbl...[vbcol=seagreen]
> thanks -
> how do i go about attaching the mdf file?
> to export it?
> thanks
> Jeff
> file to a text file
> inside SQL server. After
> export the data from
> message
