how to transfer from MySql to Management Studio

Question

I have database which works on MySql. And i need to copy it to another computer where there is only management studio. i create .sql file from MySql and tried to run it in studio but always have syntax errors. How to do it correctly?

 CREATE TABLE branches (
  idbranches int(11) NOT NULL AUTO_INCREMENT,
  address varchar(200) NOT NULL,

e.g. incorrect syntax for "AUTO_INCREMENT"

Answer 1

The SQL Server syntax is:

CREATE TABLE branches (
  idbranches int identity(1, 1) not null,
  address varchar(200) NOT NULL
);