One SQL database or Two

I have the Personal Webpage kit and it requires 2 databases; do I need to purchase 2 SQL databases or can I just run it with one. If I can use one how do I set that up.


Thanks
DW

 

All of your tables can exist in the same database.

There are several options for what you're asking.

1. Use a local copy of SQL Server management tools to migrate the tables into one DB.
2. Transferone of yourexisting databases into your remote SQL Server, the other could use Access or XML.

I haven't looked at the Personalkit but I will if you end up needing help with it.
Salute,
Mark

 

I wish I had too much money, can you tell me how I use only one when form what I can tell the Personal Web kit uses two. I am new at this so I appreciate all the help.

Thanks
DW

 

Look inside both databases.
Chances are the aspnetdb has your DB roles, security objects.

I'm working on some Video tutorials that will show how SQL Server can be used to merge them.
It just requires basic SQL knowledge and a good tool, like Query Analyzer in SQL 2000 or Management in 2005.

What do you have at your disposal currently for working with these? (Visual Studio, SQL Server, etc.)
Salute,
Mark

 

THis may sound dumb but there is two mdf files in the database: aspnetdb and personal. which do I use?

 

When you say you need 2 dbs do you mean you need the aspnetdb and another one for your work, or 2 dbs for different purposes?


The personal site kit can be set up to use forms authentication all out of one db if that what you need to do, in which case you only need to pay for one. Near as I can tell from the Discount policies if you need to separate dbs your stuck paying for 2. The other sneaky work around is to add a SQL express db to the app_data folder (or, in the case of the personal web kit let it create the aspnetdb.mdf and then expand or rename/reconfigure it).


I've just gone through the exercise so if you need details on either of the solutions let me know.