Database - Revision history

Ashhawk: BSN link flagged for maintenance - using AWB

2022-02-01T16:05:51Z

BSN link flagged for maintenance - using AWB

2010-05-23T22:48:25Z

‎Creating a blank database from scratch

2010-05-23T22:47:26Z

‎Creating a blank database from scratch

2010-02-05T18:06:26Z

‎Creating a blank database from scratch

2010-02-05T17:36:06Z

the creation scripts are here, that's a suitable source for schema information

2010-02-05T17:33:45Z

‎Creating a blank database from scratch

2010-02-05T17:33:29Z

‎Creating a blank database from scratch: link to the core and single player DABDATA file

2009-12-02T23:12:15Z

‎Creating a blank database from scratch: add a note that might catch someone using a fresh blank database with version 1.01 of the toolset

2009-11-18T19:16:01Z

‎Creating a blank database from scratch: see Manual database installation

2009-11-06T19:02:18Z

backup and restore batch file is included with the toolset

← Older revision		Revision as of 16:05, 1 February 2022
Line 1:		Line 1:
		+	{{BSN link}}
		+
	The toolset uses a named SQL instance, so you want to connect with your client using the format:		The toolset uses a named SQL instance, so you want to connect with your client using the format:

@@ Line 101: / Line 101: @@
 Also:
 For international users (If Your sql server 2005 uses different database collations by default):
 When creating db_dragonage_content please remember to change collation from Your local one to:
-[b]SQL_Latin1_General_CP1_CI_AS[/b], this is the only collation that guarantees You that those .sql batch scripts will work properly.
 == Setting up SQL Express 2005 manually ==

@@ Line 80: / Line 80: @@
 * bw_db_write
 * bw_db_lock
 You may get three warnings that begin "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...". These are not a problem, the script is creating stored procedures that refer to tables that only get added later in the SQL script.
@@ Line 96: / Line 97: @@
 If you wish to attempt to import the core and single player campaign resources you can find a [[DADBDATA]] file containing them at [http://social.bioware.com/project/1331/#files].
 == Setting up SQL Express 2005 manually ==

@@ Line 72: / Line 72: @@
 *[[Content Create Script.sql]] sets up the tables. If you have a slow connection note that this page is over half a megabyte in size.
 *[[Core Data Script.sql]] puts some basic core data into the tables that the toolset needs in order to run.
 Before running them you'll have to ensure that your database has the following three roles:
 * bw_db_read
 * bw_db_write

← Older revision		Revision as of 17:36, 5 February 2010
Line 1:		Line 1:
−	~~At the moment our internal documentation on the database schema used by the toolset is too out of date to be posted here; it will be added at some time in the future.~~
−
	The toolset uses a named SQL instance, so you want to connect with your client using the format:		The toolset uses a named SQL instance, so you want to connect with your client using the format:

@@ Line 94: / Line 94: @@
 You'll then be able to start the toolset and change modules as you please.
-If you wish to attempt to import the core and single player campaign resources you can find a [[DABDATA]] file containing them at [http://social.bioware.com/project/1331/#files].
+If you wish to attempt to import the core and single player campaign resources you can find a [[DADBDATA]] file containing them at [http://social.bioware.com/project/1331/#files].
 == Setting up SQL Express 2005 manually ==

← Older revision		Revision as of 17:33, 5 February 2010
Line 93:		Line 93:

	You'll then be able to start the toolset and change modules as you please.		You'll then be able to start the toolset and change modules as you please.
		+
		+	If you wish to attempt to import the core and single player campaign resources you can find a [[DABDATA]] file containing them at [http://social.bioware.com/project/1331/#files].

	== Setting up SQL Express 2005 manually ==		== Setting up SQL Express 2005 manually ==

← Older revision		Revision as of 23:12, 2 December 2009
Line 81:		Line 81:

	You may get three warnings that begin "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...". These are not a problem, the script is creating stored procedures that refer to tables that only get added later in the SQL script.		You may get three warnings that begin "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...". These are not a problem, the script is creating stored procedures that refer to tables that only get added later in the SQL script.
		+
		+	Note: as of version 1.01 of the toolset, upon first being installed the toolset will default to the "Demo" module when it can't find the previously-open module in the database. This script doesn't create the Demo module, so the toolset will give an error message and fail to run. To fix this, open the [[DefaultSettings.xml]] file in Dragon Age\tools and change
		+
		+	<CampaignID>3</CampaignID>
		+
		+	to
		+
		+	<CampaignID>2</CampaignID>
		+
		+	(CampaignID 2 is the Single Player module.)
		+
		+	You'll then be able to start the toolset and change modules as you please.

	== Setting up SQL Express 2005 manually ==		== Setting up SQL Express 2005 manually ==

← Older revision		Revision as of 19:16, 18 November 2009
Line 81:		Line 81:

	You may get three warnings that begin "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...". These are not a problem, the script is creating stored procedures that refer to tables that only get added later in the SQL script.		You may get three warnings that begin "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...". These are not a problem, the script is creating stored procedures that refer to tables that only get added later in the SQL script.
		+
		+	== Setting up SQL Express 2005 manually ==
		+
		+	See [[Manual database installation]].

	== Troubleshooting ==		== Troubleshooting ==

← Older revision		Revision as of 19:02, 6 November 2009
Line 27:		Line 27:

	You can then run the batch files to backup your database and restore it, with you controlling the file names and such.		You can then run the batch files to backup your database and restore it, with you controlling the file names and such.
		+
		+	The toolset comes with a simple batch file for backups and restores, you can find it in the Dragon Age\tools\DatabaseUtilities\Backup_Restore directory. Edit the "config.ini" file to set the names and locations for database backup and restore files.

	=== Builder to builder export ===		=== Builder to builder export ===