> I tried to backup database in SQL Server Standard and then restore it
> into SQL Server Express but it didn't work.
It should work. What happened? Did you get an error message?
> Are there any tools that can extract SQL clauses to create database,
> tables and data inserts into file? Or any other method to transfer
> database/ data from SQL Server Standard to SQL Server Express?
The Database Publish Wizard can be a choice.
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-
A410-371A838E570A&displaylang=en

Signature
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx