'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?
As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

Downgrade DTS Package

All
Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
imported into SQL Server 7. If so what is the process to migrate a SQL
Server 2000 DTS Package to SQL Server 7.
ThanksBackwards migration is not supported... You could create a script in SQL 2k
and try to load it,,, fixing any issues that you find... Or you could simply
start from scratch in SQL 7
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"David" <David@.discussions.microsoft.com> wrote in message
news:143BA10B-AAD6-4A76-B178-726FDA00EB75@.microsoft.com...
> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can
> be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.
> Thanks|||Try
save DTS package as Visual Basic file
open in VB and modify the following section of the code
'----
' Save or execute package
'----
goPackage.SaveToSQLServer "SQL7SERVERNAME", "sa", "your SQL 7 sa password"
'goPackage.Execute
'tracePackageError goPackage
'goPackage.Uninitialize
Run the vb program.
Thanks & Rate the Postings.
-Ravi-
"David" wrote:
> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.
> Thanks

Downgrade DTS Package

All
Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
imported into SQL Server 7. If so what is the process to migrate a SQL
Server 2000 DTS Package to SQL Server 7.
Thanks
Backwards migration is not supported... You could create a script in SQL 2k
and try to load it,,, fixing any issues that you find... Or you could simply
start from scratch in SQL 7
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"David" <David@.discussions.microsoft.com> wrote in message
news:143BA10B-AAD6-4A76-B178-726FDA00EB75@.microsoft.com...
> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can
> be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.
> Thanks
|||Try
save DTS package as Visual Basic file
open in VB and modify the following section of the code
'----
' Save or execute package
'----
goPackage.SaveToSQLServer "SQL7SERVERNAME", "sa", "your SQL 7 sa password"
'goPackage.Execute
'tracePackageError goPackage
'goPackage.Uninitialize
Run the vb program.
Thanks & Rate the Postings.
-Ravi-
"David" wrote:

> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.

> Thanks
sql

Downgrade DTS Package

All
Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
imported into SQL Server 7. If so what is the process to migrate a SQL
Server 2000 DTS Package to SQL Server 7.
ThanksBackwards migration is not supported... You could create a script in SQL 2k
and try to load it,,, fixing any issues that you find... Or you could simply
start from scratch in SQL 7
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"David" <David@.discussions.microsoft.com> wrote in message
news:143BA10B-AAD6-4A76-B178-726FDA00EB75@.microsoft.com...
> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can
> be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.
> Thanks|||Try
save DTS package as Visual Basic file
open in VB and modify the following section of the code
'----
' Save or execute package
'----
goPackage.SaveToSQLServer "SQL7SERVERNAME", "sa", "your SQL 7 sa password"
'goPackage.Execute
'tracePackageError goPackage
'goPackage.Uninitialize
Run the vb program.
Thanks & Rate the Postings.
-Ravi-
"David" wrote:

> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can b
e
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.

> Thanks

Domain Migration

I am trying to migrate users accounts from a 2000 Server to 2003 server I am changing domain names and the new domain a is a child domain off a parent domain. I have created a trust on both domain servers and the parent domain and I have created administrative users on each domain I am using the ADMIT migration tool and can get all the way through it then get an access denied when it trys to create the accounts. The knowledge bases on this say I need a Domain Admin user on each domains for the other domain. Being in a child domain it does not let me create this I have created users and added the admistrative group for each user this should give the rights to create the users on the new domain, but still am getting the access denied.

Does anyone know what I am missing on this? Any help would be greatly appreciated.

thanks,

Shawn

I would suggest posting this question on a Windows forum, given that you are doing Windows operations, not SQL Server operations.

Thanks
Laurentiu

|||

Is your login is a part of domain and local admin on both of those domains?

As suggested above its better to search through the Windows related forums, if this is not a SQL related issue.