merge serveral databases - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

merge serveral databases

Author

Topic

bambusel
Starting Member

1 Post

Posted - 2010-01-18 : 08:40:16

Hello together,

we would like to merge several database on one SQL Server 2008.
At the moment all database are running on different Servers with SQL Server 2005. The Problem is that some databases have different "server collations"? How can I handle that?

thanks in advance.
bambusel

Kristen
Test

22859 Posts

Posted - 2010-01-18 : 09:37:16

I think this would work:

On SQL 2008 server:

Make Linked Server to ServerA (SQL 2005)


INSERT INTO TableA(Col1name, Col2name, Col3name, ...)
SELECT MyInt1, MyVarchar2 COLLATE SQL_Latin1_General_CP1_CI_AS, MyDatetime3, ...
FROM ServerA.dbo.DatabaseA.TableA

(substitute the collation you want to use for the target column)

Repeat for each server / database / table.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources