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

Thanks

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"
<Stup88@discussions.microsoft.com> wrote:

> 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
>
> Thanks

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

"Aaron Bertrand [SQL Server MVP]" wrote:

> 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"
> <Stup88@discussions.microsoft.com> wrote:
>
> > 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
> >
> > Thanks
>
>

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

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C49D09AE.BBF7%ten.xoc@dnartreb.noraa...
> 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"
> <Stup88@discussions.microsoft.com> wrote:
>
>> 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
>>
>> Thanks
>

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

"Norman Yuan" wrote:

> Note the OP said the production server is SQL SERVER 2000? He cannot attach
> ..MDF from SQL Server2005/Express to SQL Server2000.
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:C49D09AE.BBF7%ten.xoc@dnartreb.noraa...
> > 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"
> > <Stup88@discussions.microsoft.com> wrote:
> >
> >> 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
> >>
> >> Thanks
> >
>
>

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.

"Stup88" <Stup88@discussions.microsoft.com> wrote in message
news:8F501D54-6B32-4AF3-98F9-8C1F88B646BF@microsoft.com...
> Just wanted to verify.. so this is not possible because of the different
> versions.. any other way to do this ?
>
> "Norman Yuan" wrote:
>
>> Note the OP said the production server is SQL SERVER 2000? He cannot
>> attach
>> ..MDF from SQL Server2005/Express to SQL Server2000.
>>
>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in
>> message
>> news:C49D09AE.BBF7%ten.xoc@dnartreb.noraa...
>> > 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"
>> > <Stup88@discussions.microsoft.com> wrote:
>> >
>> >> 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
>> >>
>> >> Thanks
>> >
>>
>>

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 ?

"Norman Yuan" wrote:

> 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.
>
> "Stup88" <Stup88@discussions.microsoft.com> wrote in message
> news:8F501D54-6B32-4AF3-98F9-8C1F88B646BF@microsoft.com...
> > Just wanted to verify.. so this is not possible because of the different
> > versions.. any other way to do this ?
> >
> > "Norman Yuan" wrote:
> >
> >> Note the OP said the production server is SQL SERVER 2000? He cannot
> >> attach
> >> ..MDF from SQL Server2005/Express to SQL Server2000.
> >>
> >> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in
> >> message
> >> news:C49D09AE.BBF7%ten.xoc@dnartreb.noraa...
> >> > 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"
> >> > <Stup88@discussions.microsoft.com> wrote:
> >> >
> >> >> 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
> >> >>
> >> >> Thanks
> >> >
> >>
> >>
>
>

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

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


"Stup88" <Stup88@discussions.microsoft.com> wrote in message
news:3BFC7EBC-8882-4EA0-B807-8328CE686A5F@microsoft.com...
> 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 ?
>
> "Norman Yuan" wrote:
>
>> 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.
>>
>> "Stup88" <Stup88@discussions.microsoft.com> wrote in message
>> news:8F501D54-6B32-4AF3-98F9-8C1F88B646BF@microsoft.com...
>> > Just wanted to verify.. so this is not possible because of the different
>> > versions.. any other way to do this ?
>> >
>> > "Norman Yuan" wrote:
>> >
>> >> Note the OP said the production server is SQL SERVER 2000? He cannot
>> >> attach
>> >> ..MDF from SQL Server2005/Express to SQL Server2000.
>> >>
>> >> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in
>> >> message
>> >> news:C49D09AE.BBF7%ten.xoc@dnartreb.noraa...
>> >> > 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"
>> >> > <Stup88@discussions.microsoft.com> wrote:
>> >> >
>> >> >> 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
>> >> >>
>> >> >> Thanks
>> >> >
>> >>
>> >>
>>
>>