0
votes
1answer
77 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
1
vote
1answer
39 views

migrate old MS SQL 4.2 (circa 1992) db dump to MS SQL 2005

I have a cusotmer who sent me their database dump, which I'm supposed to import into MS SQL 2005 and have a look at. Unfortunately, it is (I am told) from MS SQL 4.2 (circa 1992), (which apparently ...
1
vote
2answers
785 views

Migrating to a new SQL Server machine: should master database be restored?

I'm currently working on a migration plan to migrate our SQL Server to some new hardware. The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
0
votes
3answers
99 views

Migrate data from SQL 2005 (hosted) to SQL 2008 (in-house server)

We have a databased hosted with a "commodity" SQL hosting company. It's currently hosted on a SQL 2005 server. We have just configured a dedicated server (to which we have "root" access) running ...
1
vote
1answer
368 views

SQL 2005 change IP address and subnet

I have to move few sql servers to a new subnet ( change IP address and mask only ), need to know what should be best practice or correct way of doing this? the sql servers are not in cluster. Thank ...
3
votes
1answer
686 views

MSSQL 2005 migration to 2008 Express Edition - Any complications?

I've developed an application that uses ASP.NET, Linq-to-SQL and MSSQL 2005. However, I would like to migrate it to MSSQL 2008. I don't have MSSQL 2008, so I was wondering if it's possible for me to ...
2
votes
5answers
114 views

Developed against MSSQL 2005 - host only has MSSQL 2008

Hey, I've been developing my ASP.NET application against SQL Server 2005. The web host I intend to go with only supports SQL Server 2008. Will there be any changes I have to make in my database so ...
0
votes
3answers
112 views

Are there any potential problems moving from 32 bit Enterprise to 64 bit Standard SQL Server 2005

I've been looking at an upgrade to my SQL Server 2005 Enterprise edition. I'm specifically looking to upgrade as I'm hitting the limit of my 2 CPUs at the moment. It looks like I could move to 64 bit ...
4
votes
5answers
358 views

What is the best way to move 20+ databases to a new database server? SQL 2005

Current database server: SQL Server 2005 - Windows Server 2003 New destination database server: SQL Server 2005 - Windows Server 2003 Enterprise - VM Ware image Current database server has 20+ ...
2
votes
3answers
950 views

Migrating SQL server 2000 database to SQL server 2005

Can any one suggest variou ways of migrating a database from SQL server 2000 to 2005. How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that ...
0
votes
3answers
801 views

SQL Server Migration Assistant for Oracle problem

I've recently installed SSMA on my computer and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server. I've mapped the needed schemas from oracle ...
0
votes
5answers
750 views

Oracle to SQL Migration

I'm currently starting a project for an Oracle to SQL 2008 migration. Since I'm currently reading the official SSMA Guide to Migrating from Oracle to SQL Server 2005 i'd like advice and pointers from ...
1
vote
3answers
197 views

SQL Server File Data

I have been tasked with migrating file data from one SQL server DB to another. There is currently a SQL server 2005 DB that is stored file in an image type field. There is a migration happening that ...
10
votes
6answers
17k views

How to migrate from SQL Server 2005 to 2008

How do you migrate SQL Server 2005 databases to SQL Server 2008? Is it as easy as backing up 2005 databases and simply restore in 2008? Are there any compatibility issues? Is SQL Server Reporting ...