How can we help you today? How can we help you today?
John Oliver
Activity overview Badges (0) Posts (1) Comments (4)

Activity overview

Latest activity by John Oliver

Pete, Thanks, I thought it would be in your software somewhere, was just looking for it. As I said, my SQL skills are minimal at best. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. New User - Require Help with Collation issues
Pete, Thanks, I thought it would be in your software somewhere, was just looking for it. As I said, my SQL skills are minimal at best.
0 votes
Pete, I will get a snapshot to you as soon as I work out how to do this. It should be with you within the hour. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. New User - Require Help with Collation issues
Pete, I will get a snapshot to you as soon as I work out how to do this. It should be with you within the hour.
0 votes
Peter I am getting the following error during the Syncronisation of the database between the two databases - The following error message was returned from the SQL Server: [468] Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. The following SQL command caused the error: /* $Header: /Tools/SQLScripts/Templates/ApplicationDB/S002_IdoColumnWithAliasView.sql 1 3/30/07 3:38p Tblosser $ */ /* Copyright � 2007 Infor Global Solutions Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. The word and design marks set forth herein are trademarks and/or registered trademarks of Infor Global Solutions Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. All other trademarks listed herein are the property of their respective owners. */ CREATE VIEW [dbo].[IdoColumnWithAliasView] AS WITH ColumnSchema (TableName, ColumnName, OrdinalPosition, DataType, DataLength, DataDecimalPos, ColumnDataType) AS ( SELECT TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , dbo.MongooseTypeFromSqlType(DATA_TYPE) , CASE WHEN DATA_TYPE IN (N'text', N'char', N'varchar', N'sysname') THEN CHARACTER_MAXIMUM_LENGTH WHEN DATA_TYPE IN (N'ntext', N'nchar', N'nvarchar') THEN CHARACTER_MAXIMUM_LENGTH WHEN DATA_TYPE IN (N'numeric', N'decimal') THEN NUMERIC_PRECISION ELSE NULL END , CASE WHEN DATA_TYPE IN (N'numeric', N'decimal') THEN NUMERIC_SCALE ELSE NULL END , ISNULL(DOMAIN_NAME, DATA_TYPE) FROM INFORMATION_SCHEMA.COLUMNS ) SELECT CollectionName , ColumnSchema.TableName , ColumnSchema.ColumnName , ColumnSchema.OrdinalPosition , TableAlias , TableAlias + '.' + ColumnSchema.ColumnName AS ColumnWithAlias , TableType , JoinType , JoinText , DevelopmentFlag , ColumnSchema.DataType , ColumnSchema.DataLength , ColumnSchema.DataDecimalPos , ColumnSchema.ColumnDataType FROM ido.Tables t INNER JOIN ColumnSchema ON ColumnSchema.TableName = t.TableName If there is anything you can do, I would be most grateful, as I am being contsantly asked if this has been resolved yet. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. New User - Require Help with Collation issues
Peter I am getting the following error during the Syncronisation of the database between the two databases - The following error message was returned from the SQL Server: [468] Cannot resolve the c...
0 votes
Peter, Many thanks, I will try this and let you know if this works. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. New User - Require Help with Collation issues
Peter, Many thanks, I will try this and let you know if this works.
0 votes
New User - Require Help with Collation issues
  1. Community
  2. SQL Data Compare Previous Versions
I was wondering if any of you guys can help. I have a database with collation set as Latin1_General_CI_AS. I want to extract all the data into a new database with the collation on this database se...
2 followers 7 comments 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1