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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Best way for data migration in sql server

Author  Topic 

nicck
Starting Member

1 Post

Posted - 2013-12-30 : 09:35:43
We have an existing windows application using a database. We migrated to web application using the same database, but made few changes like changing the table name and added few columns in tables.
Now if my customer has this windows application already installed in his system and he now migrates to web application.
My requirement is , if my customer already has the windows application database installed in his system, he need not install new database for web application.
What is the best way to migrate the changes from web application database to the already installed windows application database?

rtown
Yak Posting Veteran

53 Posts

Posted - 2013-12-31 : 10:50:45
You could just script the new fields and apply them manually to the new DB. If you are just importing and have concerns about what data goes where try out a db management program. I use navicat to import data regularly, you can choose what data goes to what field and it will stop you if there are any hang ups.
Go to Top of Page
   

- Advertisement -