Hi, I am working on a test installation of SQL 2K5 but I need to copy a D.B. from SQL 2K5 to a SQL 2K. I tried with backup but the restore in SQL 2K does not work, anyone can help me?
Many thanks,
Fabio.
Hi,
either import the data from SQL Server 2000 or script out the structure and the data (which would be some more work to do) Backups made in SQL Server 2005 are not readable in SQL Server 2000.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Thanks Jens,
the D.B. is too big (about 200 tables) and I have no network access to make an import.
I hoped that was possible to restore it from sql 2k5 to sql 2k ...
I think I have to install a sql2k5 instance on my developement PC.
Fabio.
|||For the data transfer you must have to go import/export route and for the schema you can script the database so.
No comments:
Post a Comment