Re-invent ASP.NET Hosting Community / Web Site Development / Design / SQL 2008/2005/2000 and MS Access Database / restore MS SQL 2000 database to MS SQL 2005 ?? / Latest PostsInstantForum.NET v4.1.4Re-invent ASP.NET Hosting Communityhttp://community.re-invent.com/community@re-invent.comMon, 05 Jan 2009 23:11:55 GMT20RE: restore MS SQL 2000 database to MS SQL 2005 ??http://community.re-invent.com/Topic484-4-1.aspx<P>Hello,</P><P>Upload the .mdf file to your FTP site and let our Support know when it is there and where it was uploaded and they can attach the database to your SQL 2005.</P>Sun, 21 Jan 2007 10:03:00 GMTRe-invent (Plato)restore MS SQL 2000 database to MS SQL 2005 ??http://community.re-invent.com/Topic484-4-1.aspxI have SQL 2000 database backup-ed on local computer.<br>Database has lot of tables, and every table has lot of data in it. Primary and foreign keys are set up, as well as table collation.<br><br>can you please help me, which is the most "nicest" way of restoring this database to SQL SERVER 2005 located on your server ?<br>Sun, 21 Jan 2007 07:55:00 GMTzoran123456