SQL Collations with Version 6

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SQL Collations with Version 6

Postby olli_d » Mon Jan 26, 2009 3:00 pm

I'm missing the SQL Collations. Is that really true? What about compatibilty to old database schema?
Or did I miss some options to set the collation?
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

Postby Michelle Taylor » Mon Jan 26, 2009 5:05 pm

Where are you missing the SQL Collations, and what versions of SQL Server are you using in the project? We tried to only provide collations that the target version of SQL Server would accept, but we shouldn't have deleted all the backwards compatibility collations from the list at any point.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

SQL Collations on SQL 2005

Postby olli_d » Mon Jan 26, 2009 5:16 pm

All MS SQL Server Versions 2005 below use SQL Collations. I'm using SQL_Latin1_General_CP1_CI_AS.
Please see 'new database' dialog or 'server properties' dialog during install to see these entries. With Packager 5 all was fine.
Chris
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

Collations are present - until ... AND another Bug

Postby olli_d » Wed Jan 28, 2009 4:58 pm

... until I select SQL 2005 compatibility level -> then the disappear from the combobox. <server default> is selected instead.
AND the List does NOT show any SQL-Collations anymore.

BTW: 2nd Bug: Leaving the Compatibilty Level emtpy to keep the SQL-Collation entry (should have been my workaround) will result in an non executable package)!

Haven't got any feedback for 24 hours, redgate :-(. I'm stuck right now.

Chris
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

... anybody out there?

Postby olli_d » Thu Jan 29, 2009 7:58 pm

Hi Michelle,
any news on this topic? I do need support.
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

Postby Michelle Taylor » Thu Jan 29, 2009 8:10 pm

The compatibility level making the sql collation list not contain SQL collations is a bug :(. I managed to make a package when I tried to go for one leaving the compatibility level empty with the collation you specified, and haven't been able to make that fail.

If you could give me some more details on exactly what you're doing when the package fails to execute? (i.e. C# or exe, what database version on each side, what things you change on the last screen of the wizard)
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Postby olli_d » Thu Jan 29, 2009 8:33 pm

MS Vista SP1 x64 english 4 GB RAM
SQL 2005 Standard SP3 german
Packager:
- pack all tables, all records
- .exe not compressed
- SQL Collation SQL_Latin CP1_CI_AS
- Recovery simple
- Compatibility <server default> !not having touched this combo!
- no changes on file locations
- no change on database size
- no change on database name

- package name with xxx_20090127


I was now also able to create a new package the way you described. The process failed before - probably because I set up the package based on a Packager v5 file.

Do you need any further info?
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

Postby Michelle Taylor » Fri Jan 30, 2009 12:54 pm

Are you now able to use the workaround of not setting the compatibility level (and we'll hopefully fix the bug when we next have a new version of Packager), or is there an immediate problem you still have with the product?

I'll have a go at reproducing the backwards compatibility problem, but it might be easier if you could send me the offending project file (to michelle.taylor@red-gate.com).
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

It's blocking now

Postby olli_d » Thu Oct 29, 2009 2:45 pm

Michelle,
the error in SQL Packager is going to be blocking now because 'Server default' collation is different to our sql-collation.
Some update scripts do not work with these different collations. When you previously asked whether the problem allows a workaround I never expected the error not to be fixed. I definitely need an update now. The error already took us much time to work around, communicate an fix.

Please save our good impression on Red Gate Products and Support.
Chris
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am

It's fixed now

Postby olli_d » Mon Nov 09, 2009 7:34 am

Many thanks for your quick and solid fix of the error and the direct contact to you, Chris during fixing the problem.
Packager is doing now what it is supposed to do.
Chris
olli_d
 
Posts: 9
Joined: Fri Nov 30, 2007 7:50 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests