| Author |
Topic |
|
Kaninen
Starting Member
5 Posts |
 Posted - 2012-03-01 : 08:22:23
|
| Hi, I'm a complete n00b who has a SQL-file. I need to get the information from the SQL-file into something I can read and understand. Where do I start, or should I just give up and hire someone to convert it for me? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-03-01 : 08:50:04
|
Without seeing the file, my bet is to hire someone to do the job for you.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-01 : 08:50:19
|
First of all, do you know what file is that ? Is it a backup of a database ? Is it from Microsoft SQL Server ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Kaninen
Starting Member
5 Posts |
Posted - 2012-03-01 : 08:55:28
|
| It's a backup of a database. The file is a .sql, but I don't know if it's from Microsoft SQL Server. Thanks alot for replies. I was hoping there was an easy converter programme. But I've googled my fingers sore without finding anything. ;) |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-01 : 09:27:38
|
.SQL is text, just use a normal text editor to open
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Kaninen
Starting Member
5 Posts |
Posted - 2012-03-01 : 09:47:06
|
| Ah, thanks alot! :) |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-01 : 09:49:34
|
| .sql is not a backup of a database. It might be a script of a database or any other piece of SQL code at all. It might be Oracle, it might be MySQL, etc.--Gail ShawSQL Server MVP |
|
|
|
Kaninen
Starting Member
5 Posts |
Posted - 2012-03-02 : 05:24:00
|
| Okay, but is it possible to organize the content of the .sql file in a table of some sort?Is this easy, or should I get someone to do this for me? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-02 : 06:04:17
|
| Depends what's in there. It will probably be scripts of tables, views, procedures and other objects and insert statements for the data. Probably. However it will only run successfully if applied against the correct database engine. If that's a script from a MySQL database it won't run against an Oracle server, etc--Gail ShawSQL Server MVP |
|
|
|
Kaninen
Starting Member
5 Posts |
Posted - 2012-03-04 : 15:50:25
|
| OKay, thanks alot for the help! :) |
|
|
|
|
N00b has problem with converting SQL to text