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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-19 : 10:52:52
|
| Eric writes "I have tried finding answers in the manual at Microsoft's website, this website, others forums and so on. The answers I see are close but not enough to help me. I have a backup database file called BackupWEbserverSQL.mdb on my test box which is running Windows Server 2003, IIS 6 and SQL Server Management Studio Express v9.0.2047.The backup db file is from a SQL Enterprise Manager v8.0 on another server. So that part is done. What I need to do now (that I can't find answers to) is "how do I import this db into Express so that I can use the entire structure of the database I backed up as a template, so I can then remove the stuff I dont need and keep what I do need for my test project?Is there an easy way to export a db from one server then somehow get it into Express without having to write a lot of script?" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2007-01-31 : 19:45:07
|
| Is this really an MS Access question? You might have more luck in another forum...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Exporting DB then Importing