Create DB from mdf file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stup88 - 11 Jul 2008 17:45 GMT

I have a developer who has give me a mdf file she would like uploaded to our
production sql 2000 machine, what is the best process to do this.

I believe it was created in sql express 2005 edition.

Please help

Thanks

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 11 Jul 2008 17:59 GMT

And she dd not provide an LDF file? If the file was properly detached from
SQL Server 2005 then you might be able to use the stored procedure
sp_attach_single_file_db. Otherwise, I would ask her to either make a
backup you can restore, or detach the database correctly and provide you
with both the MDF and LDF files.

A

On 7/11/08 12:45 PM, in article
7BDCC239-7DAA-46DD-9BDE-930AF3C88221@microsoft.com, "Stup88"

> I have a developer who has give me a mdf file she would like uploaded to our
> production sql 2000 machine, what is the best process to do this.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Stup88 - 11 Jul 2008 18:04 GMT

I have both files.. sorry for the confussion I should have included that in
the first place..

So with that said.. what is the best approach.. use enterprise manager and
attach DB ? or what

> And she dd not provide an LDF file? If the file was properly detached from
> SQL Server 2005 then you might be able to use the stored procedure
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message

Norman Yuan - 11 Jul 2008 18:16 GMT

Note the OP said the production server is SQL SERVER 2000? He cannot attach
.MDF from SQL Server2005/Express to SQL Server2000.

> And she dd not provide an LDF file? If the file was properly detached
> from
[quoted text clipped - 17 lines]
>>
>> Thanks

Reply to this Message

Stup88 - 11 Jul 2008 19:31 GMT

Just wanted to verify.. so this is not possible because of the different
versions.. any other way to do this ?

> Note the OP said the production server is SQL SERVER 2000? He cannot attach
> ..MDF from SQL Server2005/Express to SQL Server2000.
[quoted text clipped - 20 lines]
> >>
> >> Thanks

Reply to this Message

Norman Yuan - 11 Jul 2008 21:01 GMT

Your can only attach .MDF file generated from SQL Server2005 to a SQL
Server2005 or SQL Server2008 instance. Then, you can use Enterprise
Manager/SQL Server Management Studio to do import/export between the two SQL
Servers (2000 and 2005). If you only need the database's structure, then you
can let the original author to script out the database structure and run the
scripts on your SQL Server2000 to get the database created. If you do need
the data, then, importing/exporting would be the only way to do it.

> Just wanted to verify.. so this is not possible because of the different
> versions.. any other way to do this ?
[quoted text clipped - 26 lines]
>> >>
>> >> Thanks

Reply to this Message

Stup88 - 11 Jul 2008 21:45 GMT

So I can have the author export the data from 2005 and then I can import it
into a sql 2000 Db... But thats only data.. thats not structure is it ?

> Your can only attach .MDF file generated from SQL Server2005 to a SQL
> Server2005 or SQL Server2008 instance. Then, you can use Enterprise
[quoted text clipped - 34 lines]
> >> >>
> >> >> Thanks

Reply to this Message

Tibor Karaszi - 12 Jul 2008 06:51 GMT

There are functionality in the 2005 tools to generate scripts for the DDL.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> So I can have the author export the data from 2005 and then I can import it
> into a sql 2000 Db... But thats only data.. thats not structure is it ?
[quoted text clipped - 37 lines]
>> >> >>
>> >> >> Thanks

Reply to this Message