[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Access database table was converted to SQL table

I converted an Access database table to a SQL table. The vendor has made changes to the original Access table that I already converted. Is there some type of compare I can run to see what changes need to be applied to the structure of the SQL table. Thanks.
0
kitsapcoder
Asked:
kitsapcoder
  • 2
2 Solutions
 
messen1975Commented:
One of two things -- you could export the database designs to VISIO and compare the Diagrams side by side.

Or you could Reupsize the db and use SQLDBCompare to do the comparison  Link: http://www.sharewareconnection.com/sqldbcompare.htm
0
 
Martin-SmithCommented:
Cross-Database Comparator Pro (http://www.dbbalance.com/download.htm) Will let you compare and synch directly from Access to SQL
0
 
messen1975Commented:
Nice app -- thanks for that link Martin.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now