SQL Server Export Attempt. Need help.

[vern021]

Anyone knows how to export your current database in MySQL management studio 2008 to another PC in order to open it? It wasn't taught in my class. My friends and I need to present our project but we need the database from our PCs. We can't open it from our laptop since it's not connected with the school's server(unless there's a way to do it(we don't know how to do it either))

 

Any advice would help and I highly appreciate!

[kichilron]

You can always export your DB as an SQL-script. I don't know how exactly how / where in MySQL 2008 - but you should be able to find it somewhere.

 

If you export it as an SQL-Script from your current DB you can insert everything (including the existing Data as well as structure) into a new DB on a different device.

 

Hope that helps.

[vern021]

You can always export your DB as an SQL-script. I don't know how exactly how / where in MySQL 2008 - but you should be able to find it somewhere.

 

If you export it as an SQL-Script from your current DB you can insert everything (including the existing Data as well as structure) into a new DB on a different device.

 

Hope that helps.

Does it need authentication to access the file?

[RaidenLeeChin]

kichilron is right, i do this all the time. Just be sure that you either create the main database manually first or you have a create database statement at the top of your exported sql statements because sometimes it does not put it in for you.

 

 

Does it need authentication to access the file?

I don't think you need authentication if you have direct access to the server,

 

You can do either one:
1. You can copy and paste the exported code in the file into the script editor in 2008 and run it

or

2. Find an option to load the exported file and run it.

[Ohio]

Instead of going the steps to export the DB a SQL scripts as other people are suggesting (If you plan to copy data, drop and create scripts, or anything like that it will take a fair amount of setup). You could just go to the database you want to copy to another location, right click on it, and click Tasks -> Back Up. Then all you would want to change (I think you have to do this, I've never saved in the default location) click the Add... button next to the listed Desctination, pick a folder where you want to save this backup and give the file a name (extension is .bak), then remove the default location (it will likely default to a backup folder in your SQL install location). Once you're done simply click OK and it should save the file. 

 

Now copy the file you created over to the other computer, open up the management studio, right click Databases and click Restore Database..., type your database name in the To database: section (the database should not already exist, it will create the database if you type something that doesn't exist in this box, that is what we want). Then select "From device:", click the browse to your .bak file, the restore should then show up in the "Select the backup sets to restore", click ok, and you should be golden. 

 

I apologize if this is scattered, I'm at work and have been pulled away from this post about 10 times now haha. Let me know if you would like me to clear something up. 

[mikebald]

I am confused by your question, you mention "MySQL" and "Server Management Studio 2008" and those are 2 distinct things. MySQL and MSSQL are 2 different RDBMSs and it doesn't appear as if Microsoft Server Management Studio works with MySQL.

 

If you're wrong about the MySQL part then ZEJ's answer is probably going to be the easiest method. If you're confused about the Server Management Studio 2008 then the other answers provided will be your best bet.

[rockking1379]

Anyone knows how to export your current database in MySQL management studio 2008 to another PC in order to open it? It wasn't taught in my class. My friends and I need to present our project but we need the database from our PCs. We can't open it from our laptop since it's not connected with the school's server(unless there's a way to do it(we don't know how to do it either))

 

Any advice would help and I highly appreciate!

lets just get some shit very clear here. there is a MAJOR difference between MSSQL which use management studio and MySQL which does not and has its own other set of tools available to work with. have your tech in line when you need help. now if it was mysql, then you mysqldump at the command line, read up a bit on it. however since your using management studio i am going to assume that you are you MSSQL server 2008, in which case your on your own