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.htmlThis 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