On Fri, Aug 17, 2012 at 12:31 PM, Rafael Copquin <[email protected]> wrote: > To those of you who are more familiar than me with SQL Server. > > I have a client that uses SQL Server Express 2008 version 10.50.2500.0 > in Spanish > > In my computer I have version 10.0.1600.22 in English > > I backed up a database from my client's and want to restore it in my > version of SQL Server, but my system says that the versions do not match > because my client's is newer than my SQL version > > I need it because I am making modifications to my VFP program that uses > SQL Server as a backend engine and bringing the database home allows me > to fool around with the data with no danger of messing up my client's > business > > How can I solve this? ---------------------
You could set up SSIS jobs to update your database. If you are tweaking SPROCS they just copy that script over to the db that needs the update and run it. You can set up a package for each table you want and then truncate your data, export everything in. Or you could take advantage of a datetime column and update anything on your system from theirs by date time > your system's date time. You could upgrade your version as well. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmylextjs4c4rvc8yxhgrhoac6uryzr8mezwc4f73fxt...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
