thomasm1948
asked on
Microsoft SQL Copy and Replace Tables from one Database to Another
Hi,
How can i copy and replace Tables from a source database to another target database.
The issue that i have is that we just started to use reporting services and it points to a database on another server (our reporting server) to distribute reports. In the past we just did a MS SQL database restore to the server and manually ran reports. This solution will not work now because we have created custom stored procedures on the report database and the restore will overwrite the stored procedures
Thank you for all of your help in advance
How can i copy and replace Tables from a source database to another target database.
The issue that i have is that we just started to use reporting services and it points to a database on another server (our reporting server) to distribute reports. In the past we just did a MS SQL database restore to the server and manually ran reports. This solution will not work now because we have created custom stored procedures on the report database and the restore will overwrite the stored procedures
Thank you for all of your help in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On target machine the Table already exists or not?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I got it to work, I went importing the tables versus exporting and it worked out perfectly