Importing tables/cells into another database

I am running a web site that that classifieds and using MS SQL 2000 or 2005
(I got both installed and afraid If I take 2000 off the classifieds will no
longer function).
Anyway, I want to put a forum on the site also.
The setup includes a scrip to create al the tables for the new database.
I would rather use the original database with the users on it and modify it
some way so that I can continue to have current users on the new forum.
Is there a way to simplify a merge between these two?
I am guessing I will have to modify the forum software to look for the
element names of user/password for the classifieds database.
Thanks for any help, hints or tips.
GB
hi,
GeekBoy wrote:
> I am running a web site that that classifieds and using MS SQL 2000
> or 2005 (I got both installed and afraid If I take 2000 off the
> classifieds will no longer function).
> Anyway, I want to put a forum on the site also.
> The setup includes a scrip to create al the tables for the new
> database.
> I would rather use the original database with the users on it and
> modify it some way so that I can continue to have current users on
> the new forum.
> Is there a way to simplify a merge between these two?
>
without elements such as table design it's actually impossible to answer to
this one..
you can probably "add" you old users into the new database model, but,
again, it's impossibile to answer without elements

> I am guessing I will have to modify the forum software to look for the
> element names of user/password for the classifieds database.
>
you probably will, and I'd guess it'll not work at all if you just maintain
the old database you already have.. just a bet...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:5ealvmF37mtgoU1@.mid.individual.net...
> hi,
> GeekBoy wrote:
> without elements such as table design it's actually impossible to answer
> to this one..
> you can probably "add" you old users into the new database model, but,
> again, it's impossibile to answer without elements
> you probably will, and I'd guess it'll not work at all if you just
> maintain the old database you already have.. just a bet...
>
Well it seems it is a bit more complicated than that. The passwords on the
database for the forum are encrypted.
Any more suggestions on how to use both?
Thanks for the kind reply so far.
|||hi,
GeekBoy wrote:
> Well it seems it is a bit more complicated than that.
:D you can take it for granted :D

>The passwords
> on the database for the forum are encrypted.
> Any more suggestions on how to use both?
>
you can't for sure "use both".. you "coul'd" transfer users (and encrypted
pwds) to the "new" user's table via a "traditional" INSERT INTO .. SELECT
statement, but you obviously have to consider the metadata difference of the
2 tables... if the 2 designs are quiet "close", you can probably get it
done, but if they strongly differ you'll get in troubles..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:5ecnouF38c1sbU1@.mid.individual.net...
> hi,
> GeekBoy wrote:
> :D you can take it for granted :D
> you can't for sure "use both".. you "coul'd" transfer users (and encrypted
> pwds) to the "new" user's table via a "traditional" INSERT INTO .. SELECT
> statement, but you obviously have to consider the metadata difference of
> the 2 tables... if the 2 designs are quiet "close", you can probably get
> it done, but if they strongly differ you'll get in troubles..
> --
what about making 2 tables in the same database?
Then making a routine for writing user name and password into other
database?

> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>