Hi,

I tried to use sql express 2005 DTS converstion wizard from within the
Managment Studio and gerenate sql scripts to recreate the database into sql
2000.

So far, the scripts can't be excuted in sql 2000. What am I doing wrong?

In Sql express 2005, I did

1. right click on the database
2. tasks->gerneate scripts
3. in the properties, I select sql 2000 as the target
4. select recreate tables
5. select the tables to genreate


the generated sql script when loaded in sql 2000 enterpirse manager, can't
execute for whatever reason.

any tips, links are appreicated.

thanks

Liming:
any detail ? what 's your data? Have your data any question? e.g.
data Constraints,
Relationship Collections etc.

Hello,

You are not supposed to run the script generated in SQL 2005 on SQL 2000.
This is because some system views in the script do not exist in SQL 2000.

If you want to run the script, you need to comment the line including these
system views manually.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Hey Gab,

Yeah, I have a ton of relationships, constraints. Just saw Peter's reply. I
guess the answer is that there is no automatic ways, you gotta at least
manually edit the scripts..

I get Errors like "Error at Go statement".. very simple ones. oh well, I'll
just recreate those tables in 2000. only 20-30 anyway.


"Gabriel" <huangdalong827 (AT) 163 (DOT) com> wrote

Hello Peter,

This is what I have in my gerneated sql statement by 2005

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[TaskStatus]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TaskStatus](
[TaskStatusID] [int] IDENTITY(1,1) NOT NULL,
[StatusName] [nchar](10) NULL,
[StatusCreatedOn] [datetime] NULL,
[StatusUpdatedOn] [datetime] NULL,
CONSTRAINT [PK_TaskStatus] PRIMARY KEY CLUSTERED
(
[TaskStatusID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

.....
.....

GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id =
OBJECT_ID(N'[dbo].[FK_Tasks_aspnet_Membership]') AND parent_object_id =
OBJECT_ID(N'[dbo].[Tasks]'))
ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT
[FK_Tasks_aspnet_Membership] FOREIGN KEY([AssignedByID])
REFERENCES [dbo].[aspnet_Membership] ([UserId])

what can I modify to make it work on 2000? aspnet_membership and what not
are already created by aspnet_regsql command. I'm not really good at this
store procedure stuff, any pointers on how to get the above statement to
wokr is really appreicated it.

In addition, if I deleted the above statment and the alikes, only the
relationships won't be created, but i'll still get my other normal tables
created correct?


thanks
""privatenews"" <petery (AT) online (DOT) microsoft.com> wrote