Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Anyone using NAnt in their development process?

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-04-19 : 16:01:49
We use NAnt to build our databases during development. I wrote a task to restore a database. I'm planning to release it publicly but I'd love some "beta" testers first. If anyone is usuing NAnt and needs to restore a database please resond here or email me (http://weblogs.sqlteam.com/billg/contact.aspx) and I'll send you what I've got.

Features:

-- Automatically corrects the physical file name locations
-- Can set recovery mode to simple
-- Can shrink the database

A key limitation at this point is that it's limited to a single data file and is untested with multiple transaction log files.

As you can guess we restore a series of backups during our build process. Depending on the server, they need to go into a variety of directories. This is my solution. Let me know if anyone is interested.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-04-20 : 05:49:01
graz, what is the N.A.n.t?
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-04-20 : 06:55:18
NAnt is a tool for building (and possibly deploying) software. Or in my case databases. A very simple example is at http://nant.sourceforge.net/release/latest/help/fundamentals/buildfiles.html

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-04-20 : 08:05:28
NAnt's build files are written in XML. Each build file contains one
project and a number of targets. Each target contains a number of tasks.

Thanks, graz. Btw, there is a trailing "bad" dot in your link.
Go to Top of Page
   

- Advertisement -