Closed. This question needs to be more focused . It is not currently accepting answers.

Want to improve this question? Update the question so it focuses on one problem only by editing this post .

Closed 2 days ago.
Improve this question

We decided to split one database into two databases because they are 2 sister companies and both of them are using the same database. what are the solutions ? _I can get "create data base script" then use the script for creating the second one!.but I think practically I can use Replication instead (?) and if yes which kind of data replication is suggested?
_Keeping common tables in both databases and then by using of CompanyID column, which should be in most tables, I can split uncommon tables based on the companyID.