Forum Discussion
JNICKRAND
Apr 09, 2024Copper Contributor
Comparing fields from Microsoft SQL database to Microsoft server Compat database
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
- olafhelperBronze Contributor
JNICKRAND , there is a free & powerfull tool available for: GitHub - ErikEJ/SqlCeToolbox: SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
- JNICKRANDCopper Contributor
olafhelper , Thanks I will check it out.