Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
j4ydh
Starting Member
18 Posts |
 Posted - 2011-01-24 : 06:22:43
|
| Hi,I am trying to supply a complete (or as near as possible) database with tables relations in tact similar to a .bak file for use with restore. The company I have sent the bak file to are asking for an export file. I am using MS SQL 2008 SERVER MANAGEMENT STUDIO.I am unable to find a simple walk through that helps package the information for transfer out.Thank you in advance.J |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-24 : 09:38:30
|
| What's wrong with just sending 'em a backup? |
 |
|
|
j4ydh
Starting Member
18 Posts |
Posted - 2011-01-24 : 09:49:13
|
| Hi Russell,That's what we did. Makes perfect sense. Unfortunately they are on Macs and Linux and are unable to recognise the .bak file.We are looking at generating a script file with data.CheersJ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-24 : 15:50:23
|
| I don't think a script file is going to work either. You can create scripts of all of your objects (e.g. CREATE TABLE/VIEW/PROCEDURE, etc...), but those scripts are all SQL Server specific.The scripts can be generated by in a couple of ways, but the easiest for a single item is to right-click it in SSMS and generate script.Again, these scripts will not be useful for that company since they are probably on MySQL which is different. Every single script will have to be evaluated and modified to use the equivalent MySQL statements and data types and then manually run in the correct dependency order to build the system.And then, once the objects have been built - the data would have to be imported.This is not a trivial exercise and is something that will take quite a bit of effort.Jeff |
|
|
|
|
|
|
Export database as complete as a bak restore