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
>

Importing excel data into new table in MS SQL Server

I have installed SQL Server Managemert Server Express .... I am wondering how to import data from an excel spreadsheet?

.. Silent Running

hi,

you "traditionally" use a linked server to perform that kind of operation, but, if you install the DTSWizard from the Microsoft SQL Server 2005 Express Edtion Toolkit, you have some kind of user interface for that as well..

regards

|||

I download the toolkit but i didn't see any thing about a dtswizard

|||

hi,

no shortcut is created for it... but have a look in \Program Files\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe ..

regards

Importing excel data into new table in MS SQL Server

I have installed SQL Server Managemert Server Express .... I am wondering how to import data from an excel spreadsheet?

.. Silent Running

hi,

you "traditionally" use a linked server to perform that kind of operation, but, if you install the DTSWizard from the Microsoft SQL Server 2005 Express Edtion Toolkit, you have some kind of user interface for that as well..

regards

|||

I download the toolkit but i didn't see any thing about a dtswizard

|||

hi,

no shortcut is created for it... but have a look in \Program Files\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe ..

regards

Importing data into SQL Server 2005 Eval version

Just installed SQL Server 2005 Eval version and Management Studio does not display any Import/Export functions to load data into tables of an existing database. I thought that this feature was turned off only in Management Studio Express.

Using the Object Explorer, right-click on the database, select [Tasks], then [Import Data...] or [Export Data...]

importing a SQL 2000 database

I installed SQL 2005 Express and Server Management Studio Express (CTP) but now what's the easiest way to import a database from a SQL2000 server?

Steve

I've been using backup (from 2000) and restore (to 2005) with zero issues....