CipherIS
asked on
SQL Extract a record to a text file
I need to extract a record from DEV to a text file and then import the record into QA. I do not have permission to run xp_cmdshell and I do not have permission to link the database to the QA server.
If I copy and past the fields I lose the special characters in them so I need to export and then import.
Any ideas?
If I copy and past the fields I lose the special characters in them so I need to export and then import.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can use the sql server import export wizard