comparing columns on 2 differnt server

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

General SQL Server Forums

New to SQL Server Programming

comparing columns on 2 differnt server

Author

Topic

shebert
Yak Posting Veteran

85 Posts

Posted - 2009-08-20 : 11:22:40

Hello
i can run this on one server serverA
SELECT
column_name=syscolumns.name
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype='U'
and sysobjects.name ='PhlatTrac_Order'

and this on a differnt server serverB

SELECT
Vcolumn_name=syscolumns.name
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype='V'
and sysobjects.name ='PhlatTrac_order'

can I run them both in one query analyser I want to compaire the columns to see if the view code can needs modification....

I have lot of view to compare

shebert
Yak Posting Veteran

85 Posts

Posted - 2009-08-20 : 11:36:05

I think I can accomplish with SSIS. any thoghts...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources