jasonbrandt3
asked on
Export table structure and contents to .sql file
What is the easiest way to export a table structure and the data to a .sql script to be run on other servers. I need to distribute this to another organizaton, I would like them to just run the script. Is it possible to do this in SSIS?
take a full backup and restore it on the other servers
ASKER
I realize I can backup the database and restore on the other servers. What I want is a .sql script containing the table structure as in create table blah (.....)
with the data
insert into blah......
Hope that makes sense. It's easily done in mysql by creating a dump file, I'd like to do something similar.
with the data
insert into blah......
Hope that makes sense. It's easily done in mysql by creating a dump file, I'd like to do something similar.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
its not so easy as in MySQL, and requires more processor resource
ASKER
Just wanted to add a last comment, MS actually makes a free product for just this task, it's called the database publishing wizard which allows you to create dump files.