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 |
|
NewToASP
Starting Member
7 Posts |
 Posted - 2012-03-02 : 12:41:15
|
| I have a little problem. I am using the ASPNETDB for users and roles but my web server only allows one database at the moment so I need to either do one of two things.Somehow, add the ASPNETDB into my existing database or manually create all of the tables exactly how they are in the ASPNETDB schema.Since I am not a database specialist I would rather opt for the 1st option. But is it possible?I mainly use SQL Management Studio 2008 for my database access. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-02 : 12:43:18
|
| why not export tables along with data to your databse?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2012-03-02 : 14:17:45
|
Get hosting that allows multiple databases and save yourself from using a bandaid fix. Moving forward if it is best to have two databases, you should not combine them now due to if you ever expand later on you will only make it more difficult.If for some reason that is not a realistic option, you can use SSIS to export data and import it to your hosting database.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
|
|
|
|
Is it possible to to combine 2 databases?