Restoring favourites after database change pgql - ms-sql

Question

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!

Viktor Steinmann · Answer

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.

Brant Schroeder · Answer

@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/