Comparing fields from Microsoft SQL database to Microsoft server Compat database

Copper Contributor

I have two databases in two different locations. One is a SQL database and one is a SQL server compact database. Is it possible to create a script to compare the fields in the SQL database to the fields in the SQL server compact database? Basically, what I am trying to do is if a field exists in the SQL database (but not the SQL server compact database),  the script would create that field in the SQL Server compact database.

Thanks for any help!

2 Replies