Skip to main content
Mattastic
Inspiring
July 20, 2006
Answered

SQL Server moving data

Hi Folks,

I've recently decided to change the structure of my Db in SQL Server 2000, I have setup a new Db and created the tables and made the changes, however I need to import all the old records from my old DB is this possible?

Thankyou
This topic is closed to new replies. Start a new post to keep the conversation going.
MattasticCorrect answer
Inspiring
July 21, 2006
thankyou
View reply

4 replies

Dan_Bracuk
Inspiring
July 20, 2006
Using Enterprise Manager,
1. Ensure db2 has permission to select from db1.
2. From db2 run a bunch of queries that resemble

insert into thistable (field1, field2, etc)
select this, that, etc
from somewhere in db1
where whatever.
Translate
The_ScareCrow
Inspiring
July 21, 2006
When using the wizard in enterprise manager to import data, you can point the columns to each other.
When you select the tables (source) to import and then select the tables to import to (destination), there is another option to the right "Transform" click the elipse button, then select the transformations tab, select the buttom radio buttons and then in the window do what you need to do. Note you can also do a lot of hand coding in this window eg vbscript

Ken
Translate
MattasticAuthorCorrect answer
Inspiring
July 21, 2006
thankyou
Translate
drforbin1970
Inspiring
July 20, 2006
You can export the data from db1 and import into db2 using Enterprise Manager.

If the table layouts are different you might have to do it programmatically.
Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices