Posted by tlyczko on 09/25/06 19:13

I am new to SS2005, and I've just started working on a small test/dev
database.

I recently read that one should store things like tables, views,
constraints, etc. in the *.ndf file rather than in the *.mdf file.

Does this make it any easier to transfer/copy files or databases or
other items from test/dev to production??

If I have a database already with items in the *.mdf file, how do I
transfer things like tables, constraints, views, etc. to an *.ndf file
in another database??

I also read that one can make it the default in SS2005 to store things
in the *.ndf file, how is this done??

Thank you,
Tom

• Next in forum: Re: set default value for a char column??
• Prev in forum: Re: set default value for a char column??
• Thread view: store db objects in *.ndf vs. *.mdf??

[Reply to this message]