import/export on demand

[pygface]

Let me preface that I am an Oracle DBA and not yet completely familiar with SQL Server utilities.

I have a development environment and a test environment...
I would like to create a batch file of sorts in which I can backup (I would export in oracle) the development environment, objects and data, and restore (import in oracle) forced restore over the test environment. The reason for this is that we are a fast paced development team and it is important for us to update the test environment on demand. This may happen two-three times a day and the dba (me) is not always available to perform this task.

Thanks in advance.

 

[foxdev]

Unless you have something bizarre, it would be simplest to use the DTS (Data Transformation Services) Import Wizard to import into the Development database. You can run the Wizard and save the steps as a DTS job, which can then be scheduled or run on demand. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org