Automated Database Setup (GUI Version)

Found a copy of v3 on one of my old hdd's.
Uploaded to my server here: http://members.iinet.net.au/~samscal...l_database.zip

I've attached it to the OP too. I'll add SunnyZ' host. TY. :D:

Umm bobsobol, your exe is larger than the one I have.
I'll update my link to the same one you have.
Will still be the same address.

Maybe it is different... it's what I have on my drive. We should check each out, as I'm not sure mine isn't beta-ish. ;)

Well this is the one I had: http://members.iinet.net.au/~samscal...tabase-OLD.zip

This is the one I just dl'd from you: http://members.iinet.net.au/~samscal...l_database.zip

Okay... you found v3.2.12.1 (which my source still describes it's self as) and I had v3.3.6.1 which has some extra logic to locate various different versions of MS SQL Server.

Code:

---

If FileExists(@ProgramFilesDir & "\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE") Then
    $SQLCMD=@ProgramFilesDir & "\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE"
Else

...

---

became

Code:

---

If FileExists(@ProgramFilesDir & "\Microsoft SQL Server\80\Tools\Binn\SQLCMD.EXE") Then
    $SQLCMD=@ProgramFilesDir & "\Microsoft SQL Server\80\Tools\Binn\SQLCMD.EXE"
    $SQLVersion="SQL 2000"
ElseIf FileExists(@ProgramFilesDir & "\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE") Then
    $SQLCMD=@ProgramFilesDir & "\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE"
    $SQLVersion="SQL 2005"
ElseIf FileExists(@ProgramFilesDir & "\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE") Then
    $SQLCMD=@ProgramFilesDir & "\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"
    $SQLVersion="SQL 2008"
Else

...

---

and a couple of other *very* minor changes.

So... yea, v3.2.12.1 doesn't quite match the description I placed in the OP. ^_^

Did you know there is a built-in SQLAgent for things like this?
You can execute any queries or stored procedures daily at midnight or so. You can even write a query that stores all databases at once inside the current date folder.

Just providing some info ^^

The point was to turn the "Open each file in Notepad, select all, copy, switch to SQL Management Studio, create a database by that name, paste as a new query, run that query" into a single action. Run this program.

There are lots and lots of ways of doing it, and I personally still prefer the batch file I made which I based this on... but people wanted a GUI and not a "DOS" window. XD

I must have been in derp land when I was writing that reply...

My reply was meant for Automated Database Backup, not really for setup...

A valid, and valuable project. I heartily invite you to embark on such a project (software or guide) and to share it with us. ^_^