Respuesta: Migrar de Postgres a SQl Server MIRA:
CREATE TABLE home (
street character(60) NOT NULL,
number integer NOT NULL,
apartment character(20),
floor integer,
notes character varying(255),
"inHand" varchar(10) NOT NULL,
"visitQ" integer NOT NULL,
contact character(80) DEFAULT '' NOT NULL,
habitants smallint DEFAULT 0 NOT NULL,
phone character(20) DEFAULT '' NOT NULL,
email character(100) DEFAULT ''NOT NULL,
"user" integer,
id integer NOT NULL,
ratio integer NOT NULL,
assigned_poller integer,
status character varying(15) DEFAULT 'NOT_ASSGINED' NOT NULL,
creation_date varchar(50) NOT NULL,
exist varchar(10) NOT NULL,
lat numeric DEFAULT 0.000000 NOT NULL,
lon numeric DEFAULT 0.000000 NOT NULL,
code numeric DEFAULT 1 NOT NULL
);
Inhand y Exist , eran booleans en postgres, les puse varchar y cuando hago este insert
INSERT INTO home (street, number, apartment, floor, notes, "inHand", "visitQ", contact, habitants, phone, email, "user", id, ratio, assigned_poller, status, creation_date, exist, lat, lon, code) VALUES ('espora ', 348, 'a2 ', 2, '', false, 3, ' ', 0, ' ', ' ', 32, 976, 368, NULL, 'FINISHED', '2009-09-09', true, -34.644901, -58.567109, 1);
me tira error |