Re: How to import one DB to another using any tool
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 19 Jul 2009 22:32:39 +0000 (UTC)
John (_nospam@xxxxxxxxxxxx) writes:
Thanks for everyone's help (appreciated), but honestly, I'm no further
along. I'm simply looking for an easy GUI way of doing this. A simple
wizard, drag and drop, or whatever. I've searched up and down the net
and find countless threads with people discussing this issue in one form
or another but still no luck. Am I to believe MSFT offers no simple way
to import one DB into another, or even a bunch of tables, complete with
data, relations, etc. This is totally nuts but it comes as no surprise.
I've had nothing but problems with MSFT in recent years, literally into
the hundreds now, and that's after staunchly supporting them for many
years before that. Something is seriously wrong over there.
If you absolutely want a wizard, there is the Copy Database Wizard
in SQL Server Management Studio. Right-click the database and select
Tasks and then Copy Database in the submenu. When you start the wizard,
select the Attach method, the first.
Now, there is a catch: CDW requires Integration Services, and you
have Express. You would have to cough up 50 dollars for a license
of Developer Edition to get Integration Services.
However, to be honest, I think you are much better off using the
BACKUP and RESTORE commands, for several reasons:
1) You don't have to detach the source database, which means that it
can remain online.
2) By using commands you have something you and save and repeat. How
do you save a drag-and-drop operation?
3) The CDW is not very reliable in my opinion, although the attach
method is fairly straightforward.
Keep in mind that when working with a server application like SQL
Server, GUI functions will use any secret API, they will only use
the same command language as if you did on your own. This makes GUIs
a guessing game: you have to guess what various options mean.
You will find that using BACKUP/RESTORE to copy your database is a
swift operation. Swifter than any point-and-click GUI would ever be.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- References:
- Prev by Date: Re: How to import one DB to another using any tool
- Next by Date: RE: Need advice with table design
- Previous by thread: Re: How to import one DB to another using any tool
- Next by thread: Re: How to import one DB to another using any tool
- Index(es):
Relevant Pages
|
