ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/AnywhereTS-MSSQL/trunk/TSAdminTool/Database.cs
Revision 149 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 11:21:36 2012 UTC (10 years, 10 months ago) by william
File length: 35466 byte(s)
Diff to previous 136 (colored)

Revision 136 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 08:14:41 2012 UTC (10 years, 10 months ago) by william
File length: 35421 byte(s)
Diff to previous 135 (colored)
+ fix issues when creating tables on an empty database

Revision 135 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 05:58:56 2012 UTC (10 years, 10 months ago) by william
File length: 34633 byte(s)
Diff to previous 134 (colored)
+ tables are created for an empty database

Revision 134 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 05:13:20 2012 UTC (10 years, 10 months ago) by william
File length: 35260 byte(s)
Diff to previous 133 (colored)
+ fix errors in database
+ logon to 'master' database and refer to our database is sql statments
+ remove empty GO statements from end of .sql files

Revision 133 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 05:00:59 2012 UTC (10 years, 10 months ago) by william
File length: 35314 byte(s)
Diff to previous 132 (colored)
+ wip to get rid of errors

Revision 132 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 03:09:38 2012 UTC (10 years, 10 months ago) by william
File length: 34462 byte(s)
Diff to previous 131 (colored)

Revision 131 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 15 02:55:20 2012 UTC (10 years, 10 months ago) by william
File length: 33942 byte(s)
Diff to previous 128 (colored)
+ move all database options to DatabaseLog (even if it comes from ATSAdmin.exe)

Revision 128 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 13:01:52 2012 UTC (10 years, 10 months ago) by william
File length: 34294 byte(s)
Diff to previous 123 (colored)
+ fix RunScript ==> CommandType must be set to Text

Revision 123 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 11:14:09 2012 UTC (10 years, 10 months ago) by william
File length: 34210 byte(s)
Diff to previous 121 (colored)
+ bulk commit
-- add SQLSerer SMO support for executing TSQL commands

Revision 121 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 09:40:33 2012 UTC (10 years, 10 months ago) by william
File length: 34134 byte(s)
Diff to previous 119 (colored)
+ log context

Revision 119 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 09:08:55 2012 UTC (10 years, 10 months ago) by william
File length: 33328 byte(s)
Diff to previous 116 (colored)
+ bulk commit again

Revision 116 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 08:03:33 2012 UTC (10 years, 10 months ago) by william
File length: 33853 byte(s)
Diff to previous 107 (colored)
+ more logging work

Revision 107 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 06:24:01 2012 UTC (10 years, 10 months ago) by william
File length: 34293 byte(s)
Diff to previous 99 (colored)

Revision 99 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 04:50:27 2012 UTC (10 years, 10 months ago) by william
File length: 32326 byte(s)
Diff to previous 93 (colored)
+ bulk commit

Revision 93 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 02:35:50 2012 UTC (10 years, 10 months ago) by william
File length: 32163 byte(s)
Diff to previous 92 (colored)
+ update to .net 3.5 (so we have linq and extension support)

Revision 92 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 14 00:55:41 2012 UTC (10 years, 10 months ago) by william
File length: 32152 byte(s)
Diff to previous 90 (colored)

Revision 90 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 22:58:13 2012 UTC (10 years, 10 months ago) by william
File length: 31779 byte(s)
Diff to previous 88 (colored)

Revision 88 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 22:42:09 2012 UTC (10 years, 10 months ago) by william
File length: 32377 byte(s)
Diff to previous 87 (colored)

Revision 87 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 22:37:40 2012 UTC (10 years, 10 months ago) by william
File length: 31269 byte(s)
Diff to previous 78 (colored)
+ start implementation of AnywhereTS.DBSupport

Revision 78 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 02:21:43 2012 UTC (10 years, 10 months ago) by william
File length: 29525 byte(s)
Diff to previous 77 (colored)
+ comment-out NDC using statments that pass-in .sql script as context (this will keep the log file(s) lean an' mean)

Revision 77 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 01:35:49 2012 UTC (10 years, 10 months ago) by william
File length: 29489 byte(s)
Diff to previous 76 (colored)
+ fix syntax error in UpdateDatabase4.sql (commas cannot come after the last item in an ALTER table statement)

Revision 76 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 01:22:58 2012 UTC (10 years, 10 months ago) by william
File length: 29474 byte(s)
Diff to previous 74 (colored)
+ automatically replace the hardcoded database name AnyhwereTS with ATSGlobals.strDatabaseName when accessing SQLServerResources class

Revision 74 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 13 00:43:28 2012 UTC (10 years, 10 months ago) by william
File length: 30187 byte(s)
Diff to previous 51 (colored)
ATSGlobals.strDatabaseName

Revision 51 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 16:21:35 2012 UTC (10 years, 10 months ago) by william
File length: 25599 byte(s)
Diff to previous 50 (colored)
fix an issue that was resolved by connecting to master database instead of AnywhereTS database

Revision 50 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 14:51:57 2012 UTC (10 years, 10 months ago) by william
File length: 25535 byte(s)
Diff to previous 46 (colored)
+ define DEBUG constant and package .pdb debug files in installers

Revision 46 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 14:17:14 2012 UTC (10 years, 10 months ago) by william
File length: 25533 byte(s)
Diff to previous 45 (colored)
+ add logging across ATSAdmin Tool project

Revision 45 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 13:01:44 2012 UTC (10 years, 10 months ago) by william
File length: 24157 byte(s)
Diff to previous 44 (colored)
remove one sqlCon.close()

Revision 44 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 12:59:45 2012 UTC (10 years, 10 months ago) by william
File length: 24243 byte(s)
Diff to previous 43 (colored)
+ make sure connection is not already opened before attempted to open it

Revision 43 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 12:43:29 2012 UTC (10 years, 10 months ago) by william
File length: 23833 byte(s)
Diff to previous 41 (colored)
use ATSGlobals.strDatabaseVersion instead of duplicating the value in Database.cs

Revision 41 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 12:41:04 2012 UTC (10 years, 10 months ago) by william
File length: 23903 byte(s)
Diff to previous 40 (colored)
+ add logging in CheckVersion

Revision 40 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 12:25:58 2012 UTC (10 years, 10 months ago) by william
File length: 20064 byte(s)
Diff to previous 39 (colored)
+ more logging and changes

Revision 39 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 12:21:43 2012 UTC (10 years, 10 months ago) by william
File length: 19259 byte(s)
Diff to previous 36 (colored)
+ add logging messages

Revision 36 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 11:35:07 2012 UTC (10 years, 10 months ago) by william
File length: 16764 byte(s)
Diff to previous 33 (colored)
+ add logging library (to be shared across application)

Revision 33 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 12 10:52:05 2012 UTC (10 years, 10 months ago) by william
File length: 16819 byte(s)
Diff to previous 25 (colored)
+ attempt to add log4net support to ATSAdmin

Revision 25 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 20:39:32 2012 UTC (10 years, 10 months ago) by william
File length: 16657 byte(s)
Diff to previous 24 (colored)
+ commit current wip for non-existing database

Revision 24 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 20:15:18 2012 UTC (10 years, 10 months ago) by william
File length: 16655 byte(s)
Diff to previous 23 (colored)
+ comment-out version check and verify message

Revision 23 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 20:14:42 2012 UTC (10 years, 10 months ago) by william
File length: 16653 byte(s)
Diff to previous 22 (colored)
+ remove database drop when database does not exist

Revision 22 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 20:13:17 2012 UTC (10 years, 10 months ago) by william
File length: 16995 byte(s)
Diff to previous 21 (colored)
+ finish support for creating tables in an empty database (incase the database are pre-created, but contains no tables)
- still have AD login issues when creating the database from scratch (ie. it did not exist to begin with)

Revision 21 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 19:34:51 2012 UTC (10 years, 10 months ago) by william
File length: 17316 byte(s)
Diff to previous 19 (colored)
+ commit wip for when database exists, but is empty

Revision 19 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 18:07:00 2012 UTC (10 years, 10 months ago) by william
File length: 15502 byte(s)
Diff to previous 18 (colored)
+ fix instancename parsing

Revision 18 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 17:45:48 2012 UTC (10 years, 10 months ago) by william
File length: 15141 byte(s)
Diff to previous 17 (colored)
+ add support to createdatabase is it does not exist

Revision 17 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 16:48:23 2012 UTC (10 years, 10 months ago) by william
File length: 14072 byte(s)
Diff to previous 10 (colored)
+ fix more references to SQLEXPRESS

Revision 10 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 11 16:01:40 2012 UTC (10 years, 10 months ago) by william
File length: 13731 byte(s)
Diff to previous 4 (colored)
SetupDatabase():
sqlCon.ConnectionString = Properties.Settings.Default.atsConnectionString;

+ this enables the user to set the connection string
(they could use SQLEXPRESS or a full Server install with named instances)
Data Source=.\SQLEXPRESS
-or-
Data Source=IPADDRES\INSTANCENAME

Revision 4 - (view) (download) (annotate) - [select for diffs]
Added Wed Jul 11 14:19:13 2012 UTC (10 years, 10 months ago) by william
File length: 13731 byte(s)
imported from https://anywherets.svn.sourceforge.net/svnroot/anywherets/trunk/
Revision: 1
Author: beartown
Date: 3:10:40 AM, Monday, June 21, 2010
Message:
First upload. Still todo in order to get a fully working product: Replace Thinstation images with vanilla Thinstation, modify ImageDesigntimeConfig.cs, ImageRuntimeConfig.cs in order to support the Thinstation image

Convenience Links

Links to HEAD: (view) (download) (annotate)

Compare Revisions

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a