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 |
|
anbrutog
Starting Member
4 Posts |
 Posted - 2010-08-24 : 06:52:40
|
Hi there,
This is an easy question so no doubt it shouldn't take too much explaining.
I administer a SQL2000 DB that for the most part sits in the corner and requires zero attention. It consists of two DB's , a live DB and a test DB. The test DB has become rather outdated, and as a result the powers that be wish to have the test contain the same data as the live DB.
So quite simply , how do I import the ( dumped ) data from the live site to the test site??
From googling , this is closest i've found ..
http://www.databasedesign-resource.com/import-and-export-in-sql-server.html
This is what I've attempted..
Right click on the Database I want to import into.
All tasks ,import data, bringing up the Data Transformation Services Import / Export Wizard.
Data source , Microsoft OLE DB provider for SQL server.
Server - local.
Use SQL Authentication.
Select Live Database as 'where I want to copy data from' , then next.
Repeat as above for 'where I want to import data to', selecting the test database.
Select 'Copy Table(s) and views(s) from the source database' , click next.
Unfortunately , the above hasn't worked, and it seems like its had the effect of blanking the live database.
Can anyone give me advice as to what I should be doing??
AB. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anbrutog
Starting Member
4 Posts |
Posted - 2010-08-24 : 12:43:09
|
Hi Tkizer,
Thanks for the reply. Had a look at your link , and to be honest I think its a bit overkill for what I'm trying to do. I've sorted the problem , a simply restore of the DB ( right click , restore ) seemed to do the trick!!
Thanks again,
AB |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL2000 Noob question - Importing a DB