|
|
| Author |
Thread Statistics | Show CCP posts - 12 post(s) |
FireFoxx80
   |
Posted - 2006.01.05 14:00:00 -
[1]
Does this include outposts in the station data?
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.24 21:35:00 -
[2]
Edited by: FireFoxx80 on 24/01/2006 21:38:05
TSQL :) t20 I wub j00! It's beautiful, simply beautiful!
For all the people talking about the SQL format, it should be fairly easy to do a find/replace to change the SQL syntax. Besides, you should only realy need to change the table definition and the COMMIT commands.
Else, import them into MSDE, and use the widely available tools to migrate them into mySQL.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.25 12:00:00 -
[3]
Non T2 build requirements are minerals only, I would imagine they are in the blueprint tables? I've never investigated blueprint stuff, so I cannot be certain.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.25 13:59:00 -
[4]
 Originally by: Iron Wraith
thanks t20, you make us nerds very happy 
I think we prefer to be called application developers.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.30 12:43:00 -
[5]
Maybe a SQL techie can help this:
I run the SQL import scripts via Query Analyser, and they go in fine. Well all except the scripts that are over ~2MB, where I get an 'insufficient memory' error.
Query Analyser is being run on a different system to the SQL Server.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.30 16:58:00 -
[6]
Originally by: Gal'tashec
Originally by: FireFoxx80
Maybe a SQL techie can help this:
I run the SQL import scripts via Query Analyser, and they go in fine. Well all except the scripts that are over ~2MB, where I get an 'insufficient memory' error.
Query Analyser is being run on a different system to the SQL Server.
Use the Import Data feature of the Enterprise Manager instead. I had the same problem as you but was able to import it without any problems
Do you just import the CSV values into tables created with the CREATE TABLE defs in the SQL scripts?
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.02.01 11:20:00 -
[7]
Yeah, could parse and batch the SQL using VB.NET I suppose, never thought of that.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.02.02 11:08:00 -
[8]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
I use MS SQL 2003 server, with ASP/ASP.NET/PHP to use it.
23? # Missile Tool # ex: P-TMC : USAC |
|
|
| |
|