Tuesday, April 10, 2012 7:13 AM
I have two databases (let's call them DB1 and DB2) on two different servers. the DB2 has an old structure. Some tables were changed:
some columns were added in some tables, some removed, some changed the datatype or allow null values.
also some procedures were changed/ added
I need to get the DB2 into the same structure as DB1: the same table names, columns, SP. I don't care about the data, the can be deleted if needed. Is there any way, how to do it? I don't have full administration rights.
Tuesday, April 10, 2012 7:18 AM
Best solution would be to use some 3rd party apps..
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Tuesday, April 10, 2012 7:44 AM
thx for answer. I will try to use that 3rd party soft, but it's a little bit problem, because I need to split the install package 50MB into 1MB parts and send it via email to the remote computer, because on the remote computer I do not have internet access and copy paste from local to remote doesn't works :(
Any other solution appropriated
Tuesday, April 10, 2012 8:48 AMModerator
It is a bit challenging undertaking without admin rights.
Instead of emailing, how about ftp transfer?
Transfers files to and from a computer running a File Transfer Protocol (FTP) server service such as Internet Information Services. Ftp can be used interactively or in batch mode by processing ASCII text files.
You can also transfer files with the SSIS Import/Export Wizard:
Simple table compare:
Database metadata is in INFORMATION_SCHEMA views for comparison:
Kalman Toth SQL SERVER & BI TRAINING
- Edited by Kalman TothMicrosoft Community Contributor, Moderator Tuesday, April 10, 2012 8:51 AM
- Edited by Kalman TothMicrosoft Community Contributor, Moderator Tuesday, April 10, 2012 8:57 AM
- Marked As Answer by Peja TaoModerator Monday, April 16, 2012 1:50 AM
Tuesday, April 10, 2012 9:14 AMI was succesfull when transfering the files via email. now I'm trying to synchro the two DB, but need to truncate some tables before, because when synchronizing, data are copied, which leads to timeouts.
Tuesday, April 10, 2012 5:18 PM
So many tools available for this.
You can make use of Red gate tool.