Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL DATABASES WITH DIFFERENT COLLATIONS

Posted on 2008-11-16
2
Medium Priority
?
441 Views
Last Modified: 2012-05-05
I have a database with SQL_Latin1_General_CP1_CS_AS collation and another with Latin1_CS_AS collation. is it possible to transfer data between the two different databases through a custom built integration? and what are the effects of transferring data between databases with different collations?

0
Comment
Question by:David Sairai
2 Comments
 
LVL 2

Assisted Solution

by:SQLShark
SQLShark earned 135 total points
ID: 22971239
SSIS (SQL Server Integration Services) will handle the data transfer easily.  The main problem with having different collations is not transferring data, it is trying to do direct comparisions of data.  (e.g. if you are working with cross database queries.)
0
 

Accepted Solution

by:
wisc77 earned 240 total points
ID: 22981738
quires are easy.
it's easy to import them directly from one to the other just use the collate command.


it will then translate one of your IDs into the other DB language.
eg
 
select * from db1.dbo.table1 left join db2.dbo.table2 on id1 = id2 collate  SQL_Latin1_General_CP1_CS_AS 

Open in new window

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question