Simplest way to export data from a database in one environment and then import it into another database in another domain on a different SQl Svr?

MS SQL 2k in both environments.  I am a beginner at SQL but don't wish to delve too far into it as it is not really my focus.  We backed up a database and tried to restore it onto a new SQL Svr but it can't find the originating domain accounts so it no likee.  

I just want to focus on the data itself now and export it to a file and then import it into the new database so we can move on with our task.  What is a "flat file" and is that the method we should use?  I need a quick step by step and know it can't be that hard to do.  Please help.  Thanks experts!
Sp0ckyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ptjcbCommented:
The simplest method - use the IMPORT/EXPORT wizard in DTS. In Enterprise Manager, find the server you want, right-click, All Tasks - choose either import data or export data. A wizard form will appear and you walk through each screen answering the questions.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
raopsnCommented:
If you can connect from one server to the other .. you can use DTS directly to transfer the data
0
Scott PletcherSenior DBACommented:
One other possibility:

Restore the db back to its *original* server.  Remove all domain-based users from the db.  Back that modified db up and restore it to the new server.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scott PletcherSenior DBACommented:
A "flat file" is a standard sequential file, like a .txt file.

Flat files are an option also.  You could use bcp to export every table to a separate file, copy those files to the new server, then use the DTS wizard to load each of the flat files (the BULK INSERT command is faster, but requires you to use line commands in Query Analyzer).
0
Sp0ckyAuthor Commented:
Thanks everyone.  If I export the data, can I use excel 2k3 even though I am using sql2k?  Reason I am asking is because I read an informational article with some "how to" but it said export to excel 2k file and it will organize it automatically.  Then import that file into the other SQL Server.
0
ptjcbCommented:
DTS will allow you to export it out to a file. On the Export form select Excel instead of another SQL Server database. It will then ask you for the location of the Excel file.

Not sure what you mean by Excel organize the file. It won't matter to SQL Server because the tables will be organized based on your clustered indexes. It will ignore any other sort order.

0
Sp0ckyAuthor Commented:
Thanks guys!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.