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 |
|
abuhassan
105 Posts |
 Posted - 2008-08-18 : 09:57:08
|
| HiI currently have two seprate SQL Serevr Databases which are running on two seperate servers. one is a test environment and the other is the actual enviroment whihc is currently being used by users. I made changes to the test database in terms of some store proceddure etc but not changed any of the entities or the relationships etc. I wanted to get the data that the actual users have put in the database and put that data in to the test database by overwriting what is currently there. I have tried doing exports but im still having problems i just wanted to know is there an easy way of doing this?is there any features i can use to do that? I am using sql server 2000thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-18 : 10:09:18
|
| If you want only live data then its better you export them. May i know what were errors you got while exporting? how were you trying to export? |
 |
|
|
abuhassan
105 Posts |
Posted - 2008-08-18 : 10:37:59
|
| I was using the the export in enterprise manager and then using the DTS WizardIs it possible to get the data from the database as a sql script or any other way that would be eaiser? |
|
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-08-18 : 10:52:31
|
| Why not backup the production database, restore it in development and the re-apply your changes."God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
|
|
|
abuhassan
105 Posts |
Posted - 2008-08-18 : 11:00:51
|
| thnaks ill try that |
|
|
|
|
|
|
Migrating database