May 16, 2008 at 5:44 pm
I tried everything but no success. Will anyone successfully done this help me out
May 19, 2008 at 5:19 am
For a small database, a schema and data differencing tool like the Red-Gate one will generate all of the objects and populate the data.
Other than that, I suggest you script all objects in your 2005 database and create an empty SQL 2000 database. Script the drop of all foreign key constraints. Use SSIS to copy your data. Script the re-creation of all foreign key constraints.
It is a heavily manual process, but it will get the job done. I assume you only have to do it once.
May 19, 2008 at 6:51 am
You can also make use of database publishing wizard to accomplish the same. Refer, http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
[font="Verdana"]- Deepak[/font]
May 19, 2008 at 6:55 am
SSIS or DTS can do this.
It's basically script the objects, run the script (you might have errors), and then copy the data.
Since the way things are structured is different, you will have to manually correct 2k5 things back to 2k. Things like Try..Catch, don't exist in 2k.
And what is "everything?" Perhaps if you explained what didn't work, we could help you there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply