1

I'm trying to validate a customer's SQL server database by using external mapping. I want to create the mapping file on my developing computer and use it to verify the customer's server database contains all of the fields, primary keys etc. Is this possible, especially if I add a new table, can I compare the mapping file against the context retrieved from the customer server database?

Ccorock
  • 892
  • 12
  • 37
  • I'm more or less wondering if this database to object mapping can be performed on a customer's server db and then compared against a "key" mapping file so that SQL statements can be produced to correct the differences. – Ccorock Dec 10 '12 at 19:12
  • Its possible, although it may be a pain to implement. What database are you using? Implementations might vary between MsSql, MySQL, etc. – Kratz Dec 10 '12 at 20:12
  • The project is using Microsoft SQL Server 2005. – Ccorock Dec 10 '12 at 20:31
  • Im starting to shift gears into using queries like described here to validate the customer's DB, then generating SQL to make any changes. http://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-tables-in-a-database-using-tsql I'm still open for ideas though. – Ccorock Dec 10 '12 at 20:32

0 Answers0