Sunday, 30 December 2012 13:56

how to publish database file as a script file with data

Written by 
Rate this item
(0 votes)

If you want to publish your database from one database
server to another,sql server database publishing
wizard can do that.without downloading it you can
use visual studio to publish your db as .sql script
file.then you can run this script file in another
sql server to get the database with all tables and data.
I show you how -

1.from visual studio go to view menu.from there click
server explorer

2.right click on data conncetions then select add connection.
add connection dialog box will appear

3.here enter your server name.select use sql server
authentication(or windows) then user name and password.

4.then select the database below and click next.you
will see the conncetion appeared under Data connections.

5.now to publish database as script file right click
on the connection then select publish to provider.
database publishing wizard will appear.

6.then clicking next after next complete all steps by
selecting your database and location where to publish
the script,others.at last step click finish then
your script file will be generating.

7.run this script file in any blank database to
get the copy of your database.

Read 1228 times
Super User

Email This email address is being protected from spambots. You need JavaScript enabled to view it.
Login to post comments