General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi All:
> I have two sql servers. One is for development and the other one is for production. I want to import my data from production server into development server. I try to used to import from Server Enterprise Manager to import the data from production to development, however I go an login error: "Not associated with trusted Sql Server." I selected Use Windows NT Authentication option from DTS. What do I need to do to import the data into my development server.
>Thanks
Assuming you can get past that permissions error, open up the Import and Export wizard in the SQL Server group and after selecting source and destination databases, select "Transfer all objects" to create a copy of the production db to your development server/workstation. HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only