 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008sync database
I'm trying to sync two separate SQL Databases. One DB is running SQL Express and the other is running SQL 2005 full version. I'm trying to update the fields on the main DB with the development DB. Is there a better way to handle this then doing it manually one table and stored procedure at a time? Any recommendation or tools? Thanks in advance. > I'm trying to sync two separate SQL Databases. One DB is running SQL > Express and the other is running SQL 2005 full version. I'm trying to [quoted text clipped - 5 lines] > > Thanks in advance. Hi Have you thought of using replication? John I'm trying to sync the Schema. >> I'm trying to sync two separate SQL Databases. One DB is running SQL >> Express and the other is running SQL 2005 full version. I'm trying to [quoted text clipped - 10 lines] > > John > I'm trying to sync the Schema. > [quoted text clipped - 12 lines] >> >> John Hi It is usually best to build up schema change scripts as you go and then apply them when you do a release. The products Aaron mentioned are two possible solutions which are also mentioned on with a couple extra http://www.sql-server-performance.com/software/diff_compare_reviews.aspx there is also Nob Hill Database Compare http://www.nobhillsoft.com/NHDBCompare.aspx and SQLDelta http://www.sqldelta.com John Thanks. That's what i needed. >> I'm trying to sync the Schema. >> [quoted text clipped - 26 lines] > > John SQL Compare from Red Gate, or ApexSQL Diff On 6/2/08 6:00 PM, in article OXVB7wPxIHA.516@TK2MSFTNGP04.phx.gbl, "fiaola" > I'm trying to sync two separate SQL Databases. One DB is running SQL Express > and the other is running SQL 2005 full version. I'm trying to update the [quoted text clipped - 4 lines] > > Thanks in advance. download D-Softs DB Compare www.d-softs.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.