Thursday, March 8, 2012

convert SQLServer Expresss database to sqlserver2000

I have some question about SQLServer Expresss.

1. I want attach a SQLServer Expresss database to sqlserver2005.is it possible? How?

2. Can I get script by SQLServer Expresss?

3. And my important question is: How can I convert a SQLServer Expresss database to sqlserver2000?

Please help me.

Thanks in advance.

If both Express and the other edition are in the same network, register the Express to the full edition and use the Backup and Restore Wizard to Backup the database in Express then Restore in the full edition. You could try auto attach which may not work because regular attach require both MDF(Microsoft data file) and LDF(log data file). If you did not create the database with .SQL code or the GUI in Management Studio in Express then you may not have the LDF.

http://msdn2.microsoft.com/en-us/library/ms190631.aspx

Now to 2000 create a blank database in 2000 and then use DTS in 2000 to move your data and tables to 2000 because there are differences. I have posted a FAQ of how to move databases in the thread below. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

|||

Hello

as you said I tried to Backup the database in Express but I couldn't Restore it in full edition .

I get this errore: Error 3205

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

What's the problem? :(

Thanks for your helping

|||

The Backup and Restore wizard have nothing to do with .NET you are supposed to do it in Management Studio, so I have posted a FAQ which includes a Backup free chapter of a book use it. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

No comments:

Post a Comment