Data formatting problems

Packages and compresses schema and contents of SQL Server databases

Data formatting problems

Postby dhanjel » Mon Jan 25, 2010 11:18 am

In the database we have the data type DateTime on a field and it is presented in the database as 2010-01-25 10:12:11.234

Some combinations of collations and/or locale settings on computers requires that there are no lines in the date-strings.

Is it possible to remove the lines between YYYY-MM-DD in the script generated from sql packager?
dhanjel
 
Posts: 3
Joined: Mon Jan 25, 2010 10:24 am

Postby Linda Hawksworth » Wed Jan 27, 2010 4:16 pm

I have logged your request for SQL Packager to remove the dashes from the date format in the generated script (SPA-538). It will be considered for a future release of SQL Packager although we have no timescales for this at present.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby dhanjel » Mon Mar 22, 2010 12:48 pm

It's been a couple of months now with no more information on this,
is there any known workaround for this problem?
We've tried to alter the locale settings with no luck.
dhanjel
 
Posts: 3
Joined: Mon Jan 25, 2010 10:24 am

Postby Linda Hawksworth » Mon Mar 22, 2010 12:56 pm

I spoke to one of the development team about this. He asked if the iso format works, ie ISO8601 yyyy-mm-ddThh:mi:ss.mmm

Alternatively, could you tell us what collations/locales don't work?
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby dhanjel » Mon Mar 22, 2010 1:50 pm

Our export date format looks like your example above (from a swedish 2008 db) with "yyyy-mm-dd" but a French SQL express 2008 (French_CI_AS) does not accept this format when running the EXE from SQL packager.
However, if we generate the scripts, and then change the dates manually to yyyymmdd it works (when running the scripts manually).
The problem is that we generate an exe file with your tool and we have no way to change the dateformat to yyymmdd.

Is there any known workaround ?

Best regards
Daniel
dhanjel
 
Posts: 3
Joined: Mon Jan 25, 2010 10:24 am

Postby Chris Auckland » Mon May 10, 2010 6:16 pm

Just to let you know that we now have a patch avaliable that should resolve the above issue.

For more information and a download link, see

http://www.red-gate.com/messageboard/vi ... hp?p=35709
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests