Sp0cky
asked on
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you can connect from one server to the other .. you can use DTS directly to transfer the data
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER
Thanks guys!!