Exporting

Hi

I built a new sql server database and want to export its content to a .sql file. How to do it? (EM, QA ?) Thanks

Exporting the tables,views,sp ... can be done using the SQL Managment Studio. Right click and script the database.

If you want to export data then you will need a software that will generate the INSERT queries. Search google about SQL scripting ...

HTH
Regards

Export to Excel and PDF

About Excel:
I found that the content of the subreports can't export to the Excel. It
said "Subreports within table/matrix cells are ignored." Is this mean that
it is not support or there are some way to do that. the subreports is very
important to me.
About PDF:
There are Chinese content in my report that I can see it in IE but when I
export to PDF, it is all become "' ' '". I check that it is not related
to the version of Acrobat reader. I guess it is something about the
reporting server. Any idea?
Thanks,
CharlesRS is known to be very buggy with exports to both Excel and PDF. Subreports
cause lots of problems as well. Maybe this will be fixed in future versions?
"Charles Lee" <CharlesLee@.discussions.microsoft.com> wrote in message
news:8134A9FE-BEEC-418F-AB29-6BD493617B95@.microsoft.com...
> About Excel:
> I found that the content of the subreports can't export to the Excel. It
> said "Subreports within table/matrix cells are ignored." Is this mean
that
> it is not support or there are some way to do that. the subreports is
very
> important to me.
> About PDF:
> There are Chinese content in my report that I can see it in IE but when I
> export to PDF, it is all become "' ' '". I check that it is not
related
> to the version of Acrobat reader. I guess it is something about the
> reporting server. Any idea?
> Thanks,
> Charles

Export table content to sql script

Is it possible in SQL express and SQL server mangement studio express to export table content to sql script, like form table

column1 column2
1 2 2
2 3 34
3 4 234

we get script

INSERT INTO [database].[dbo].[table] ([column1] ,[column2]) VALUES (2,2)

INSERT INTO [database].[dbo].[table] ([column1] ,[column2]) VALUES (3,34)

INSERT INTO [database].[dbo].[table] ([column1] ,[column2]) VALUES (4,234)

?

If it is not possible in express editions, is it at least available in developer editions?

Have a look here: http://vyaskn.tripod.com/code.htm#inserts

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de