Divide database on two

FutureProcessing · Aug 19, 2015 · 8ac0925 · 8ac0925
1 parent f7b2def
commit 8ac0925
Show file tree

Hide file tree

Showing 4 changed files with 14 additions and 12 deletions.
diff --git a/CreateAnalyticsServiceServiceDbTables.sql b/CreateAnalyticsServiceServiceDbTables.sql
@@ -0,0 +1,10 @@
+CREATE TABLE [dbo].[Recommendations](
+	[Id] [int] IDENTITY(1,1) NOT NULL,
+	[UserEmail] [nvarchar](max) NOT NULL,
+	[MarketId] [int] NOT NULL,
+ CONSTRAINT [PK_Recommendations] PRIMARY KEY CLUSTERED 
+(
+	[Id] ASC
+)
+)
+GO
diff --git a/CreateLocalDatabase.sql b/CreateLocalDatabase.sql
@@ -1,2 +1,5 @@
 CREATE DATABASE [MarketManagementServiceDb]
 GO
+
+CREATE DATABASE [AnalyticsServiceServiceDb]
+GO
diff --git a/CreateDatabaseTables.sql → CreateMarketManagementServiceDbTables.sql b/CreateDatabaseTables.sql → CreateMarketManagementServiceDbTables.sql
@@ -22,14 +22,3 @@ CREATE TABLE [dbo].[Ratings](
 )
 )
 GO
-
-CREATE TABLE [dbo].[Recommendations](
-	[Id] [int] IDENTITY(1,1) NOT NULL,
-	[UserEmail] [nvarchar](max) NOT NULL,
-	[MarketId] [int] NOT NULL,
- CONSTRAINT [PK_Recommendations] PRIMARY KEY CLUSTERED 
-(
-	[Id] ASC
-)
-)
-GO
diff --git a/MarketFinder.CommonHost/Web.config b/MarketFinder.CommonHost/Web.config
@@ -10,7 +10,7 @@
   <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --></configSections>
   <connectionStrings>
     <add name="MarketManagementServiceDb" connectionString="Data Source=(localdb)\v11.0; Initial Catalog=MarketManagementServiceDb; Integrated Security=True; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
-    <add name="RecommendationsDb" connectionString="Data Source=(localdb)\v11.0; Initial Catalog=MarketManagementServiceDb; Integrated Security=True; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
+    <add name="RecommendationsDb" connectionString="Data Source=(localdb)\v11.0; Initial Catalog=AnalyticsServiceServiceDb; Integrated Security=True; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
   </connectionStrings>
   <appSettings></appSettings>
   <system.web>