Migration to sql server on network for access database

hi,

I migrated the Northwind database using SQL Migration Assistant for Access. it worked fine and I was able to link the access forms to Local machine SQL Server 2005 and it worked fine.

Now i want to link the same Northwind access database to Another Server on the network.

When i try to run the wizard again, it won't migrate the user objects like tables to server, it will just create a database and that is it.

it will give me this error too.

No User objects were selected.

any idea,

Thanks,

---

Fahim

Since you have already migrated to your local SQL Server, you could use the Import/Export Wizard to move the tables to a different SQL Server.

In the Object Explorer, right-click on the database, select [Task..], and then click on Export Data...

Migration Problem of Sql 2000 to SQL 2005

Hi all,

We migrated our database from SQL 2000 to SQL 2005. But we faced some problems, according to the requirements of our project we dont want to apply some constraints on some fields of some tables. But when we run the database script of our old database on SQL 2005, it applied many constraints which causing some serious problems in our project. There are about 100+ tables in our database and some one told me that we have to false every constraint manually. Now, my question is that is there any solution of our this problem.

Best Regards

hi,

can you please expand on

it applied many constraints which

can you post some SQL2000 DDL and how you like it to be in SQL2005?

regards

|||

We need some additional information here to help, could you expand on exactly what constraints you are seeing? One thing you may want to consider is that you can just move your SQL 2000 database file (data and log) to the SQL 2005 computer and attach the file, that should result in the exact same structure.

Mike

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks

Migration of crystal reports from oracle to DB2

Crystal Reports is currently using Oracle. If the database is migrated to DB2 what are the changes required to be done for crystal reports to continue to work with DB2?
Can you please point me to relevant documentation?
TIA.Is it right to assume that the following changes are needed?

- Oracle driver to be replaced with appropriate DB2 driver
- SQL statements in crystal reports that use Oracle proprietary functions/features, join syntax, etc., to be replaced with corresponding / equivalent in DB2

Please let me have your input.

Thanks in advance.

Migrating to new domain

We are migrating to a new domain. Some clients running SQL Enterprise manag
er have been migrated to a different domain than the one the actually SQL se
rver is in. When the clients were migrated they had to reregister their ser
vers in Enterprise manager.
Where is the list of servers stored that the client had registered? Registr
y key perhaps? If so which one? I would like to retain the list that the c
lient had registered or at least be able to tell them where they can get the
list.
I can retrieve a list of servers via sqldmo but only ones that are in the ne
w domain because my machine exist in the new domain.
Any help would be appreciated.GG wrote:

> We are migrating to a new domain. Some clients running SQL
> Enterprise manager have been migrated to a different domain than the
> one the actually SQL server is in. When the clients were migrated
> they had to reregister their servers in Enterprise manager. Where is
> the list of servers stored that the client had registered? Registry
> key perhaps? If so which one? I would like to retain the list that
> the client had registered or at least be able to tell them where they
> can get the list.
> I can retrieve a list of servers via sqldmo but only ones that are in
> the new domain because my machine exist in the new domain.
The SQL Servers groups with registered servers lists are usually stored in
HKCU\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered
Servers X
But I am not sure whether you can just export/import the registry keys to
the different domain, never tried this.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank You Sabastian. That is a start. Much appreciated.