Restoring favourites after database change pgql -> ms-sql

[Viktor Steinmann]

We are trying to help our uses get their favourites back according to this article: https://confluence.atlassian.com/confkb/how-to-restore-missing-favorites-after-import-from-xml-744719060.html

Extracting the old data from postgres works just fine. However the insert commands do not work for MS-SQL (e.g. this one: 

CREATE TABLE LABEL_OLD
(
  labelid bigint NOT NULL,
  name character varying(255),
  owner character varying(255),
  namespace character varying(255),
  creationdate timestamp without time zone,
  lastmoddate timestamp without time zone
); 

It seems, that MS-SQL does not like the syntax. Could someone please assist to get those queries running on MS-SQL?

Thank you! 

[Brant Schroeder]

@Viktor Steinmann 

I would suggest submitting a support issue to Atlassian so you get the correct create schema for the table.  MSSQL can only have a single timestamp on a table. You might be able to use datetime but you should check with them to see what thy would have you use.  https://support.atlassian.com/contact/

[Viktor Steinmann]

Ah, OK. Even while using Atlassian products for 10+ years, this is actually the first time, I need support, so I was not sure if this community or the support would be the right place to ask... ;-)

Trying to open a ticket now. If I get any useful answer, I will post it here later, so other community members might profit from it.