Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Steve2106
Posting Yak Master
183 Posts |
 Posted - 2012-07-03 : 09:31:33
|
| Hi There,I have been working on a web app and I now need to merge my data tables within a bigger system.Can someone point me to some tools that will help me acheive this. I know there is RedGate tools but they are a bit expensive.In the bigger system there are already tables with the names of my tables but my tables have a few additional fields. How can I copy my Table schemas into the bigger system and then copy my data in also.Thanks for any help you can give.Best Regards,Steve |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-03 : 12:03:52
|
| is this a one time thing or a continuous merge? your other option is SSIS<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
Steve2106
Posting Yak Master
183 Posts |
Posted - 2012-07-03 : 14:39:43
|
| Hi Yosiasz,It's a one time thing. We have a few applications and my one is going to join them and I need to merge my data tables to the big database that looks after the other apps.Best regards, |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-03 : 15:03:08
|
| if one time thing just use redgate free for 30 days.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-07-03 : 15:07:39
|
| run a script in your destination databaseIF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'yournewcolumn#1' AND OBJECT_NAME(object_id) = 'yourdestinationtable') BEGIN alter table dbo.yourdestinationtable add yournewcolumn#1 varchar(50) null ENDGO<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Merge DB