9 réponses à ce sujet

[The_Faeldrake]

Hi!
I was totally excited as I read about the toolset and all the cool stuff it can do and downloaded it right away. I was dissapointed however to see it uses Micrososft SQL , since I am a longtime Open Source fan and used to MySQL. So I wanted to ask if it is possible to somehow use the Toolset with MySQL instead.

Thanks in advance,
The Faeldrake

[KyleSp]

Do I have to download something to get Microsoft SQL? Cause I'm completely confused and disapointed.

[The_Faeldrake]

@KyleSp

It's bundled in the installer, but that doesn't anwser my question

[OberotenAgain]

I'd like to bump this question since I can't get the toolkit to work with the MS-Sql and much prefer a proper SQL servers anyway.

[Christopher]

Have you used the Wiki instructions?

http://social.biowar...troubleshooting



I would like to know if it works with MySQL as it would be a boon to my teams ability to work. Many webhost use MySQL db. If I get a chance later I will test it against my own Webhost services.

[jpdipity]

I am pretty sure that I saw a post from someone, in the millions of toolset install posts, stating that they were able to get it to work with MySQL. I think they had to uncheck the default database during install and change the server name on the connection tab. They also had to manually restore the database using their server name instead of the one listed in the wiki instructions.



I was thinking about trying it myself because I have not been able to get the toolset to work with MSSQL.

[BryanDerksen]

If you guys make any progress it'd definitely be something worth writing about on http://social.biowar...ex.php/Database (you might find some useful information there already - the wiki has the SQL commands for creating a blank new database from scratch, for example). We've never tried anything like this internally though so good luck. We didn't even dare to attempt running the toolset with MSSQL 2008 instead of 2005.

[fluffyamoeba]

The "sql" syntax is slightly different between the 2, so even if you can get it to connect, there's no guarantee that it won't occasionally throw sql errors at you.



For a web-based solution, just using a webhost won't be good enough. They usually only allow internal connections to the MySQL database. The easiest way is to use builder to builder as they're just xml files so version control systems like them.

[Kianouch]

Edit: do not try, doesn't work

I'm trying right now with MySQL through my VPN. I'm writing this small tutorial hoping it will work but it is very likely not to. (as mentioned right before by fluffyamoeba, the syntax is not the same)

I created an empty database on my MySQL Server: 10.8.0.1
My Windows computer on which I will use the tool set is 10.8.0.6

On the MySQL:

create database BWDATOOLSET;
 GRANT ALL PRIVILEGES ON BWDATOOLSET.* to 'dragonage'@'10.8.0.6' IDENTIFIED BY 'choosepassword';

I then installed the MySQL ODBC connector:
http://dev.mysql.com...r/odbc/5.1.html

I then created the SQL connection (Control Panel/Administrative Tools/Database Sources (ODBC)). Click on add, chose MySQL, then input the sql server's IP, the database name and your user (dragonage for me) and password. Click on test: it works. (it had to ^^)

Now for the uncertain part. We launch the Dragon Age Toolset... standby.

Uncheck "Intall SQL Server Express". Check "Restore database"

Click on "Custom Settings". Leave .\\\\\\\\BWDATOOLSET
Replace the database name by BWDATOOLSET


... and of course it does not work. I may be wrong with the way to setup the toolset against the ODBC connector. I'll have to check that, perhaps later.

Ok, final edit: it will not work.
I'll just have to install SQL Server Express. Perhaps we can at least use the latest version...

Modifié par Kianouch, 15 janvier 2011 - 10:20 .

[0x30A88]

The topic is 11 months old, I bet that the users above you have either succeeded, or left it alone by now.