I have a database in my sql management studio how can script the database schema to file so that I can put it in another device?
thanks
-
2I have no idea what you're asking, unless you're asking how to write queries.John Saunders– John Saunders2010-12-26 12:07:10 +00:00Commented Dec 26, 2010 at 12:07
-
i have a database all i need is to make it as a query when u execute it you will see a new database added to your sql management studioBobj-C– Bobj-C2010-12-26 12:23:48 +00:00Commented Dec 26, 2010 at 12:23
-
@Bobj-c - I edited your question to try to make it more clear. If I've misinterpreted, please edit it.Russ Cam– Russ Cam2010-12-26 12:49:58 +00:00Commented Dec 26, 2010 at 12:49
Add a comment
|
3 Answers
Open SQL Management -> Script Database As -> .... I think its the closest to what you mean.
Of course there are 3rd party tools for these kind of works. See RedGate.
1 Comment
samir105
In SQL Management Studio, right click database choose Tasks - Generate Scripts...
Shutdown SQL Server, copy the MDF and LDF Files to a new server and attach them on that instance by right clicking on Databases and choosing Attach. Specify the location of the files.
Alternatively, you could also backup the database from the source and restore it in the destination.
The above two methods copy all data too. If you want only the schema, Right click on the database and choose Generate SQL Scripts and follow the instructions.
4 Comments
Bobj-C
i know about attach but i want to make it query because i need to send it by e-mail and i'm in a country 128kb max connection so i can send 8 mb database (no upload) through mail got the point
xplat
RAR the database after you Detach it and if you need specific size files, just cut in pieces, you can choose file size when you compress it. Send by mail, get the pieces, unrar and attach to server. Else you could create a schema script using a tool and create a data script using another tool. RedGate does both.
Bobj-C
i tried in the best mode will be 5 mb . trust me if i cant upload more than 30kb imagine 5 mb divided by 30 kb almost 160 chunk (not good idea)
Arun
I strongly suggest against using a script. All your identity columns will get regenerated which may break foreign key relationships. The best way is to backup and restore or detach and attach. Go to the database settings and choose Logging mode as simple - This will truncate the log file. Also shrink the database before backing up or detaching. After that, compress using RAR. You should get about 80% compression.
SQL Management Studio 2008 can make query to unload Schema and data from database, but older versions if Management studio can't do it. You can use another soft to do it like an EMS SQL Management studio
