SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / Schema validation / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 20:18:27 GMT20RE: Schema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspxAnd what about try "Transfer database task" in SQL Server integration services to import remote databases and then you can do some comparations?Tue, 28 Dec 2010 11:32:20 GMTnekonecnyRE: Schema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspxI was thinking about something along those lines, I guess I was hoping somebody already had something they would could share that I could use a starting point or maybe not reinvent something somebody else already invented.Tue, 28 Dec 2010 08:17:41 GMTDustin W. JonesRE: Schema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspxWell then you could look at doing a select on sysobjects, sysindexes and syscolumns that saves those results to a flat file and then compare that to your 'master copy' of each of those files.Tue, 28 Dec 2010 08:13:11 GMTHenry TreftzRE: Schema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspx[quote]Do you want to do the compare inside or outside of SQL Server?[/quote] That is do you want a file you would import into the remote SQL server (perhaps as a new DB) and do the compare within SQL Server or do you want to export the local information to a flat file and do a flat file compare?I suppose either way would work. I would like to export the schema from the remote servers to a flat file to the local file system. I could then write a process that resides on the Central master server to collect these flat files from each remote server, import them into a table on the central master server, and then then compare the schema against a master "golden copy". There is no need to compare data, just schema.I do not think SQL compare will work for us.Tue, 28 Dec 2010 08:09:38 GMTDustin W. JonesRE: Schema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspxDo you want to do the compare inside or outside of SQL Server? That is do you want a file you would import into the remote SQL server (perhaps as a new DB) and do the compare within SQL Server or do you want to export the local information to a flat file and do a flat file compare?Also what is the amount of data (not schema) that you need to compare (in the KB, MB or GB?)?You might want to take a look at SQL Compare from Red GateMon, 27 Dec 2010 09:54:26 GMTHenry TreftzSchema validationhttp://www.sqlservercentral.com/Forums/Topic1039116-391-1.aspxOur company has over 5000 sql server instances spread out over the country. The servers are connected to our corporate central data center via a high latency satelite connection. I'm looking for a way to export a our applications schema (tables,constraints,data types..etc) to some type of flat file result (xml,text,....etc) that can be easily transmitted via our network to a central server, imported in to a database, and compared against a "golden" copy of the application database schema. Anybody have any advice or scripts that will export a database schema to a flat file? ThanksFri, 24 Dec 2010 07:49:50 GMTDustin W. Jones