Hi Team,

I am looking for the way to create/find .dbschema file from sql server database.

Please provide me details for the same.

Thanks

Hello,

Create a new database Project in SSDT (SQL Server Data Tools) and import the Schema from an existing SQL Server database.

See also How to: Build a Database Project to Generate a Compiled Schema (.dbschema) Fi

I tried this option but it shows me number of error during build. Project database updates are been taking place since many years, and most of the errors are related to missing references.

Error 200 SQL71561: Computed Column: [dbo].[Term].[TimeZoneOffSet] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [LINK].[dbo].[GetDevices].[t]::[time_zone] D.[dbo].[terminals].[time_zone]. c:\users\ss\documents\visual studio 2012\Projects\Database1\Database1\dbo\Views\terminal.sql 12 3 Database1

How to resolve such warnings and errors.

I am using 3 different servers and databases.