Database SQL Structure Question

07/22/2017 12:47 killersub#1

Alright so yesterday I was going through my old things and found my old flash drive that contained an old source that I don't quite frankly remember well. I managed to configure it to try and get it up and running but I'm not sure what MySQL management tool works with it. Mind you, the actual configuration hints to MSSQL which is microsoft's own SQL Server but I have tried implementing the SQL file with microsoft's SQL workbench to no avail. Basically, it tells me that my connection timed out everytime I dump the SQL in a database.

EDIT: I fixed the timeout issue but a different issue persists and I think it's with the SQL file itself.

The error I get is as follows:

Code:

ERROR 1064 (42000) at line 21: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[dbo].[Accounts]
GO
CREATE TABLE [dbo].[Accounts] (
[AccountID] int NOT NULL IDE' at line 1
Operation failed with exitcode 1

Now, I'm still getting myself familiarized once again with all this. With that being said, my question is this: How would I actually implement the SQL into Workbench without it kicking this error back at me?

Any advice is greatly appreciated and taken into account. Thanks again.

07/22/2017 18:36 Spirited#2

The syntax you have is still wrong for MySQL. You'd have to convert it from MsSQL to MySQL syntax to import things. What is the source called?

07/22/2017 19:06 killersub#3

Quote:

Originally Posted by Spirited

The syntax you have is still wrong for MySQL. You'd have to convert it from MsSQL to MySQL syntax to import things. What is the source called?

Thanks for the response. I believe this source was/is titled "imsoniac source". It's targeted toward patch 5017. I was trying to look around to try and convert it from mssql to mysql but I'm not so sure as to how to do that correctly.

07/23/2017 00:16 Spirited#4

Quote:

Originally Posted by killersub

Thanks for the response. I believe this source was/is titled "imsoniac source". It's targeted toward patch 5017. I was trying to look around to try and convert it from mssql to mysql but I'm not so sure as to how to do that correctly.

What do you mean you don't know how to do it correctly? Sure you do. You translate it from MsSQL to MySQL. One line at a time. The syntax for it is all online. Hell, there are probable conversion tools for it even. Or, you can just use MsSQL since the developer and express versions are free (aren't they?). Why convert to MySQL exactly?

07/23/2017 06:39 killersub#5

Quote:

Originally Posted by Spirited

What do you mean you don't know how to do it correctly? Sure you do. You translate it from MsSQL to MySQL. One line at a time. The syntax for it is all online. Hell, there are probable conversion tools for it even. Or, you can just use MsSQL since the developer and express versions are free (aren't they?). Why convert to MySQL exactly?

Well, honestly, if I can just leave it as mssql code then it would be perfect. The thing is, when I actually execute the code in workbench it tells me that my syntax is incorrect and I'm not sure why it tells me that if I'm using an MSSQL manager tool with the proper database/connnection.

07/23/2017 06:59 Spirited#6

Quote:

Originally Posted by killersub

Well, honestly, if I can just leave it as mssql code then it would be perfect. The thing is, when I actually execute the code in workbench it tells me that my syntax is incorrect and I'm not sure why it tells me that if I'm using an MSSQL manager tool with the proper database/connnection.

Well, yeah. MySQL is not Microsoft SQL / T-SQL. That's like comparing Java to C#. Sure, they're similar, but they're not the same. You can't take a Java snippet and have it compile using a C# compiler. What you're doing by placing T-SQL in workbench is pretty ridiculous. If you're going to develop using T-SQL, you'll need:

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]