Question about porting data into a new database.

We rewrote one of our legacy C#/asp.net applications that accesses a sql server 2000 database. The new database schema looks very similar to the old one. The major difference is that some of the atributes in the database tables are different. But pretty much we are using the same tables, plus or minus a few.

We need to import the old data into the new database. I have never had to undertake this type of thing before as I am not a DBA, but a developer. I feel a little scared about this whole process. My boss is open to us hiring a contractor to help with the process.

My biggest concern is the referential integrity of the database.

Can someone help me out. Does this sound like something that can be easily done or should I ask for some help.

Ralph

Can you backup existing DB and restore to the new server and "fix" it in place? As in adding/removing any columns, adding any new tables etc. This will at least guarantee you your existing data integrity. Or is this not an option?

|||

That sounds like a really good idea. I will give it some deep thought!

sql

Question -- Demo application on a CD

We have an application that accesses data from a SQL Server (2000) database.
The app is written in C# and uses SQL connections, SQL data adapters, etc
. At this time, the app uses approximately 50-60 SQL adapters.
We would like to place a demo version of the program on a CD that could be i
nstalled on a PC that does NOT have SQL Server installed and does not have a
ccess to a SQL Server installation, and without having to completely recode
all data access in the appl
ication.
Looking for any and all suggestions on how to accomplish this?MSDE is the way to go but i need instalation.
Bojidar Alexandrov|||You can distribute MSDE with the application which should be enough for a de
mo.
Do a search - there are plenty of articles about distributing it.
You can install msde, create and populate a database with the installation.

Question -- Demo application on a CD

We have an application that accesses data from a SQL Server (2000) database. The app is written in C# and uses SQL connections, SQL data adapters, etc. At this time, the app uses approximately 50-60 SQL adapters.
We would like to place a demo version of the program on a CD that could be installed on a PC that does NOT have SQL Server installed and does not have access to a SQL Server installation, and without having to completely recode all data access in the appl
ication.
Looking for any and all suggestions on how to accomplish this?
MSDE is the way to go but i need instalation.
Bojidar Alexandrov
|||You can distribute MSDE with the application which should be enough for a demo.
Do a search - there are plenty of articles about distributing it.
You can install msde, create and populate a database with the installation.