1

I am used to using Oracle Designer by creating database object definitions, then creating DDL SQL required by connecting to a database instance.

For eaxmple, when adding a new column to a table, first I add it to the table definition, then generate the DDL SQL against the development version and run it, then after testing I point to the Production instance to create the missing column in Production.

Given that there is no Designer in SQL Server what is the correct procedure to say add a column to both database instances? Is there a tool for keeping the schemas in sync?

Mark3308
  • 1,298
  • 11
  • 22
  • Oracle Designer + SQL Server? – Joel Coehoorn Jun 01 '09 at 20:37
  • Check out http://stackoverflow.com/questions/1085783/sql-server-2005-syncing-development-production-databases/3247904#3247904 basically the same question. I added an answer that shows some free tools. Not going to post it on both questions. – Gage Jul 14 '10 at 15:44

2 Answers2

1

There isn't a built in tool for keeping them in sync (that I know of), but RedGate has some commercial apps for this.

What do you mean there is no designer in SQL Server? Are you using SQL Server Management Studio?

Max Schmeling
  • 12,363
  • 14
  • 66
  • 109
1

RedGate offer a product called SQL Compare, that can be used to script out the differences between different databases.

See: http://www.red-gate.com/products/SQL_Compare/index.htm

You could also use the Database Diagrams within SQL Server Management Studio to design your database schema however this would be constrained to within a given database.

John Sansom
  • 41,005
  • 9
  • 72
  • 84
  • OK - I think I will see how Oracle Designer works with SQL Server as my company won't spend money at the moment. – Mark3308 Jun 02 '09 at 05:53