export one database sql server
using sql server 2005
want to write to a text file
or be able to recreate database
database name is 'hello'
want to write to a text file
or be able to recreate database
database name is 'hello'
Aneesh
create database Hello
ASKER
database 'hello is already created
want to use all the data from database 'hello' and put it into a sql file or a text file
want to use all the data from database 'hello' and put it into a sql file or a text file
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can also generate a sql script of all your database structure and data:
SQL Server Management Studio
right click on database name
Tasks
Generate scripts
Tick "scripts all objects in the selected database"
and in Next you can scripts anything also script data
SQL Server Management Studio
right click on database name
Tasks
Generate scripts
Tick "scripts all objects in the selected database"
and in Next you can scripts anything also script data
This is a duplicate question see here:
https://www.experts-exchange.com/questions/24838621/export-sql-server.html
https://www.experts-exchange.com/questions/24838621/export-sql-server.html