After a good holiday back to write here this time going back in time with VS 2003, I tell my case, I have VS2003 and VS2005 systems and SQL 2005 and SQL 2000 and as I have only one development machine so there I have the VS 2003, VS2005 and indeed is there no problem, also I have the SQL Server Express 2005 and I restored a database sql 2000, the truth without any problems I started working with these 3 tools, that was true until I tried to create classes DataAdapters components through VS 2003, it was impossible not generate SPs the solution to this issue was very easy and the comment, have only to install the SP1 of VS 2003 and ready. About
Use SQL2005 to handle BD that were created with the SQL2000 I have a few comments that I put here:
- restore the database from a backup data, not previously create the SQL2005, ie direct vayqn restore, do not try to create first and restore later.
- Keep in mind that they can no longer restore a SQL2005 backup made in the sql 2000, at least I found how to do it.
Well this was a short delivery and without code but I think very useful for those who no longer want to use the SQL2000 and SQL2005 to jump into, at least in their development machineSalu2