Copying Data only

[YL5956]

Hi,

I want to copy the data from our Production Server to our test server. I don't want to recreate all the objects, just import the data. What is the best way to do this? I tried using the import wizard but the data didn't move over. What am I doing wrong? Thanks in advance for your help.

 

[donutman]

You're probably not paying attention to the details...just as you did in your post. How can we help without details?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]