Data Migration Into SQL Server 2005 From Xml Files

Mar 6, 2007

Friends



Any one of you please provide step by step info for migrating sql server 2005 from xml files.



cheers :)

satish

View 1 Replies


ADVERTISEMENT

Data Migration From Oracle 10g To SQL Server 2005

Dec 14, 2007

Hi,

I'm new to SSIS.

I want to migrate data from Oracle Database to SQL Server 2005 by using SSIS Package. Client wants to migrate just data not schema. Schema is already there for SQL Server, generated through script.

I tried to migrate the data by using import-export wizard in SSIS. But, its asking for creating new tables when migrating data.

I want to migrate data in existing tables, without dropping already existed tables or creating new tables.

any suggestions ?

Regards,

Khurram

View 7 Replies View Related

Data Migration From Sql Server 7 To Sql Server 2005

Oct 25, 2007



Hi,

We have our databases running in sql server 7 and sql server 2000. Our clients are planning to migrate to sql server 2005 very soon. The front end is VB for few applications and .NET for another 2 applications.

We maintain sql server authentication and have logins created in the security folder.

I was able to download the sql server express and management studio express and restore the sql server 7 db there.
I tried to create a sql server login in sql server 2005 also. But then, the server seems to allow only windows authentication.

Can someone help please?

Also, can someone advise on what change might be necessary in the application when we migrate to 2005.

Thanks in advance,
Narayani.

View 7 Replies View Related

Migration Of DB2 Data To SQL 2005

Jul 10, 2006

Hello,

What is the best option for migration of DB2 data to SQL 2005?

DB2 is running on AIX.

Thanks,

Herman





View 1 Replies View Related

Data Migration Using SSIS In SQL 2005

Aug 8, 2006

Greetings,
I am using SQL Server 2005 and I want a clue if there is some good built-in support to do the following.
I want to transfer all the data from one source database to another destination database having same number to tables and schema like source database. I also want to ensure that the old data on the destination database should be secure too.
I have an idea that this can be done through SSIS in coding but can anyone give me a guide, tip, link, sample code that can be helpful.
Thanx a million in advance.
Regards
 

View 1 Replies View Related

Data Migration From Sql 2000 To Sql 2005

Aug 28, 2007

hi. i am currently migrating data from sql server 2000 to sql server 2005 and i was wondering if any of you can help me. i found this tutorial

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

and it seems really straight forward. does this tutorial cover everything i need to do for data migration? do i need to watch out for anything? if anyone knows of a better tutorial please let me know. thanks for the help.

View 6 Replies View Related

Help With Data Migration 2000 To 2005

Mar 7, 2008

Hi all. I'll say from the get go that I'm no SQL guru. I'm primarily a web dev who has been given the data jobs kind of by default so I'm definitely no DBA.

Anyway, having established my noobness, I have encountered an issue. The employer recently decided to upgrade our databases from 2000 to 2005 and I have been tasked to migrate the data from old to new. I have discovered the Import/Export Wizard and got it to move all the data in a dev database we use...but there was one problem. It seems that the tables in 2000 that had columns designated as identity columns do not have the identity attribute when they arrive in 2005.

I haven't figured a way to alter them to give them that attribute once they're in 2005 so I'm wondering if there's something I can do/change in the import process that would retain the identity property of the columns if I were to re-import them.

This is my first migration attempt so dumping it and starting over is no great loss...but any help would be most appreciated.

View 6 Replies View Related

Data Migration From MSAccess To SQL Express 2005

Dec 27, 2006

Hi ,

          I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle  a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access  to Table B in SQL express using SSMA?

 

Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use  the upsizing wizard of MS Access. The constraint here is that the data needs to be migrated to a completely new schema. I just need to migrate data only and no other objects.

 

Thanks

Mahesh

View 6 Replies View Related

Data Migration From Sybase 8.0 To Sqlserver 2005

Apr 7, 2006
















Hi all,

Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.

View 2 Replies View Related

Doing A Data Import Using DTS Wizard In SQL Server 2005 - Being Efficient With 5 Flat Files

Apr 13, 2006

Hi,

I'm a new user of SQL Server 2005. I have the full version installed. I also have SQL Server Business Integration Dev Studio installed. My OS is Windows XP.

I'm importing a series of 5 flat files into a database on one of the SQL Servers we have. My goal is to get 5 different tables (though perhaps I should do one and add an extra field to distinguish each import) into the database for further analysis.

I tried doing an import via DTS Wizard. There are no column names in the flat file so I defined them during the import process (all 58 of them). When I got to the end, I had an option to save the import process as a SSIS (SQL Server Integration Service) Package on:

SQL SERVER (I don't have permission for this)

or

FILE SYSTEM (did this one)

I saved the Package locally in hopes of being able to go back in, change the source file and destination table of the package and quickly get the other 4 flat files imported.

My problems are:

1) I couldn't find how to run the *.DTSX Package file to run in SQL Server Studio (basically reuse the Package with minor changes and saving me having to redefine the same 58 columns on each flat file import)

2) Tried but didn't understand how to run it in SQL Server Bus Intel Dev Studio (i.e. understanding the mapping and getting the data types right so it wouldn't error out)

3) Don't know how to make the necessary changes so that the Package handles the next source file and puts in a new destination table (do I need to do 5 CREATE TABLES so this Package has a place to run to?)

4) Does the Package need to be part of a Project to run (I haven't found how to take an existing Package and make it part of a Project/Solution)?

5) Is there a good book or online resource for just getting the basics of using SQL Server 2005 and SQL Server Business Intelligence Development Studio?

I'm really at a loss after spending a day fruitlessly on it scouring the help files, forums and experimenting around.

Hope somebody can point me in the right direction.

Regards,

Patrick Briggs,
Pasadena, CA


View 7 Replies View Related

Doing A Data Import Using DTS Wizard In SQL Server 2005 - Being Efficient With 5 Flat Files

Apr 18, 2006

I just spent some time working out how to do a seemingly simple task. I€™m sharing the steps I took to do this in hopes it saves other SQL Server 2005 users (especially newbies like myself) time.

My original question posed on several SQL newsgroups was based on this goal:


I'm importing a series of 5 flat files (all with same file layout) into a database on one of the SQL Servers we have using SQL Server 2005 (SQL Server Management Studio) . My goal is to get 5 different tables. I want to do this without having to redo all the layout criteria 4 additional times.

Below are the steps I followed to get a solution (all done in Microsoft SQL Server Management Studio):

Create the Package (data import)

1) Use the SQL Server Import Export Wizard (equivalent to SQL Server 2000 Data Transfer Wizard) to import your first flat file. At the CHOOSE DATA SOURCE window browse for your file.
2) Under the Advanced tab, you can set your Column attributes (€œoutput column width€? or €œdata type€? to name a few). I highlighted all the columns and selected €œstring [DT_STR]€? for data type. To avoid truncation errors, I selected 255 for output column width. You can name the columns whose data you are most concerned with (I did import all the available fields).
3) After choosing a server destination you will have a €œSELECT SOURCE TABLES AND VIEWS€? window pop up. Under the €œMapping€? column you can choose to tweak your mapping further editing in SQL (see Edit SQL button). I didn€™t.
4) The €œSAVE AND EXECUTE PACKAGE€? will pop up. The €œExecute Immediately€? box should be checked and you should check the €œSave SSIS Package€? (SQL Server Integration Services). When you do, select €œFile System€? for where to save this import-file-package to.
5) Click OKAY for the Package Protection Level and the €œSAVE SSIS PACKAGE€? window will appear. Browse for a path on your local computer to save to.

Modify Package (data import) for Next Use

6) In SQL Server Management Studio, browse for the Package and open it.

Preparation for SQL Task €“ box

7) You should see a screen that shows two boxes (€œPreparation for SQL Task€?) and (€œData Flow Task€?).
8) Right click on the former and select €œEdit€?.
9) On the €œSQL Statement€? row, click into the right column and select the €œ€¦€? box
10) Change the destination table (the table you will create with this package) to a meaningful name and click OK.
11) Click OK for the €œSQL Task Editor€?

Data Flow Task - box

12) Right click on the €œData Flow Task€? box and select €œEdit€?.
13) Three boxes will appear €œSourceConnectionFlatFile€?, €œData Conversion 1€?, and €œDestination - <whatever table name your original data import went to>€?. Below them is a section that displays €œConnection Managers€?

SourceConnectionFlatFile - editing

14) The first thing you will want to do is change the import source to a new flat file. You do this by going below the boxes under the €œConnection Managers€? window and right clicking on €œSourceConnectionFlatFile€? and then selecting €œEdit€?
15) Browse for the new €œFile Name€? and select it.
16) A €œMicrosoft SQL Server Management Studio€? window will pop up asking you if you want to €œkeep or reset the existing metadata€?. The metadata is just your column definitions and choosing €œYES€? to keep this makes sense if you are doing data imports on files with the same file layout.
17) Still in the €œFlat File Connection Manager Editor€? window, change the €œConnection Manager Name€? to something meaningful (I add <_> at the end and then the name of the table the flat file is going to) and click OK.

SourceConnectionFlatFile €“ box (editing)

18) Right click on the €œSourceConnectionFlatFile€? box and select €œEdit€?.
19) Your newly named €œFlat File Connection Manager€? should appear in select box.
20) Click OK, right click again on the €œSourceConnectionFlatFile€? box and select €œShow Advanced Editor€?.
21) Under the €œConnections Manager€? tab, your newly named €œFlat File Connection€? should appear (the prior step is necessary for the advanced editor to recognize your change).
22) Under the €œComponent Properties€? tab, on the €œName€? row, click into the right column and rename to something meaningful (notice the €œIdentification String€? row description changes too once you click out of the €œName€? row)
23) Under the €œColumn Mappings€? tab, just confirm you are mapping your flat file fields (€œAvailable External Columns€?) to a destination table€™s fields (€œAvailable Output Columns€?).
24) Under the €œInput and Output Properties€? tab you can check in €œFlat File Source Output€? to make modifications to either your €œExternal Columns€? or your €œOutput Columns€? €“ you shouldn€™t need to for a simple import.
((NOTE: any changes you make here would likely need to be consistent with the column properties found under the €œConnection Manager Window€? for the €œSourceConnectionFlatFile€? as well as the €œData Conversion 1€? box under the €œData Flow Tasks€? window, so exercise caution
25) NOTE: This process has worked for me by making my source columns all €œstring [DT_STR]€? data type and the output columns all €œUnicode String [DT_WSTR]€? data type.

Data Conversion 1 €“ box (editing)

26) There is nothing you need to do here. By right clicking on the €œData Conversion 1€? box and selecting €œEdit€?, you can see and change the data type of the output columns (the ones in the table your importing the flat file to). There are probably more edits one can do but they€™re beyond what I€™ve learned.

Destination - <whatever table name your original data import went to> €“ box (editing)

27) Right click on the €œDestination - <whatever table name your original data import went to>€? box and select €œShow Advanced Editor€?.
28) Select the €œComponent Properties€? tab.
29) Select the right column at the €œName€? row and change the name to something meaningful (ie. related to the source file name or the table name you€™re importing to).
30) Select the right column at the €œIdentification String€? row and it will update to this change.
31) Select the right column at the €œOpenRowSet€? and change it to the name of the table you are importing your flat file to (this should be consistent with table name under step 10).
32) Click OK
33) Select FILE and select €œSave As€¦€? and then give your package a new name that€™s meaningful (this will be helpful if you have to rerun the import of the flat file later).

Run (execute) the Revised Package (data import)

34) Go back to SQL Server Management Studio and open the Object Explorer
35) Connect to an €œIntegration Services€? component. This should essentially be a local instance (not sure where it is on the local computer or in SQL Server Management Studio on the local computer).
36) In €œObject Explorer€? go down to your €œIntegration Services€? object and expand it.
37) Expand €œStored Packages€?
38) Right click on €œFile System€? and select €œImport Package€? and an €œIMPORT PACKAGE€? window will appear
39) For €œPackage Location€? choose €œFile System€? and then browse for the €œPackage Path€?
40) Click into the €œPackage Name€? and it defaults to your Package€™s file name.
41) Click OK and the Package is imported.
42) Right click on the newly imported Package and select €œRun Package€?
43) An €œExecute Package Utility€? window appears
44) Select €œExecute€? and the package runs.

View 1 Replies View Related

Help Needed ! , Data Migration From MS Access2003 To SQL Express 2005

Dec 27, 2006



Hi ,

I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access to Table B in SQL express using SSMA?



Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use the upsizing wizard of MS Access.If there is no change in schema between source and destination databases (more of upsizing) then the process is pretty straight forward , The constraint here is that the data needs to be migrated to a new schema where the column names and number of columns can vary between the source table and destination table.. I just need to migrate data only and no other objects.



Need Help!



Thanks

Mahesh

View 1 Replies View Related

Data Migration From SQL 2000 To SQL Sever 2005 Express

Oct 24, 2007

We have a SQL Server 2000 and want to migrate to SQL Server 2005 Express.

It's possible?
SQL Server 2005 Express have support to do this?

View 6 Replies View Related

Data Migration Using Import/export Wizard SQL 2000 To SQL 2005

Mar 16, 2007

I am trying to import data from SQL 2000 to SQL 2005

The Data schemas are the same in both (tables, relationships, key and triggers).

Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 2005 database which will problably start at 1

Is there a way to do this, should I use a custom query instead of a direct table dump. If using a custom query do I need to just specify a Select query or does it have to be a specific "INSERT INTO Table ..." type query

If I do import the data directly with Identity "ON" how can I advance the identity column value to current +1 on the SQL 2005 table.

Thanks

javahar

View 3 Replies View Related

Linked Server To Text Files: Is Possible To Detect Changes Made To Those Files? (SQL Server 2005)

Sep 3, 2007

Hi gurus,

I've created a linked server (and set up the corresponding schema.ini file) in order to perform bulk-inserts from some CSV text files into SQL tables (from my standpoint the text files are just for reading purposes). The linked server works fine (I can select the data in the files without a problem).

Now the question: is possible to automatically detect when one or more of those files change in order to start the import process automatically? Something like having a trigger created on the CSV files Or there's no easy way to do that so I have, to say something, to create a Job that periodically checks if the files have changed programatically (say, recording each file's timestamp everytime is imported and comparing the recorded value with the current one, or whatever)?


Thanks a lot in advance!

View 1 Replies View Related

Migration To SQL Server 2005

Apr 21, 2008

Hi All,

Would like to know if there is any impact on application if migrated to sql server 2005?
As of now,
We have a database setup for SQL server 2000.

Thanks

View 3 Replies View Related

Migration To Sql Server 2005

May 2, 2008

Hi All,
We are planning to move from sql server 2000 and sql server 2005.
Just want to know how well is the backward compatibility and
things that we should take care of before migration.

Thanks in advance..!!!

View 2 Replies View Related

SQL SERVER 2005 Migration

Feb 12, 2008



We are currently on SQL Server 2000. We have another server that has SQL SERVER 2005. The exisiting SQL SERVER 2005, is a production server, used for Reports in SSRS 2005 In the next 2 mths, we need to migrate our dbs to SQL Server 2005. First off, I would like to TEST and ensure all the dbs/pkgs etc run fine in 2005 before I go live .
I need to know how do I get started with TESTING this, i.e. how do I move the dbs from existing 2000 server to sql server 2005?

View 5 Replies View Related

Migration From SQL Server 2005 32bit To SQL Server 2005 64bit

Oct 4, 2007

We recently migrated our 32bit instance of SQL Server 2005 SP2 to a 64bit instance of SQL Server 2005 SP2. The migration was performed by copying all .mdf and .ldf files (including master, tempdb, etc...).

Everything seems to have worked nearly flawlessly except for a few glitches seeming to relate to the master database. I am hoping there is a way to mitigate these issues without reinstalling and performing the migration again.

First, when attempting to view the Activity Monitork, I get the error:



TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

Unable to execute requested command.

Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor)

View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined. (Microsoft SQL Server, Error: 4502)



Second, the procedure: master.dbo.sp_procedure_params_rowset fails because of the line: option (OPTIMIZE CORRELATED UNION ALL).


Like I said, I know this is probably an issue arising from copying the master database, but if it is at all possible to avoid another migration, I want to.


Mike Thomas
Software Developer
The Master's College

View 14 Replies View Related

Migration Without Backup-files *.dts

Jan 10, 2007

Hello All,



I have to
migrate SQL 2000 DTS-Packages to SQL 2005. My Problem is that I didn't saved my
DTS-Packages as files and the SQL 2000 Server exist no longer.

Actually I
have only the old hard disk with the SQL 2000 databases. Do you have any ideas
what can I do?



Thanks



Jonas

View 6 Replies View Related

SQL 2000 To SQL 2005 Server Migration...

Apr 4, 2007

OK so I'm just the Network Admin here, but our DBA's are off doing other stuff. So I thought I may inquire here about how the easiest way to migrate from SQL Server 2000 to 2005? The first server I'd like to migrate is just databases with a few users, no DTS packages or anything like that... The only problem is that there are several hundred db's, so moving them one at a time is not an option. Has anyone here had successful experience with doing this? Thanks in advance for your help!
-Andrew

View 2 Replies View Related

SQL Server 2005 - FTS - Repopulate After Migration

Sep 25, 2007

I have Restored database from SQL server 2000 to SQL server 2005 and found that Full Text catalogs are not Populated.

I tried using, exec sp_fulltext_catalog 'CatalogName', 'start_full' and it showed the message
"Warning: Request to start a full-text index population on table or indexed view 'dbo.Corpora' is ignored because a population is currently active for this table or indexed view."

Please let me know on "How to Repopulate all the Full text catalogs"

Thanks.

View 1 Replies View Related

Migration Sybase To Sql Server 2005

Jan 3, 2008

Hi all,
I am Migrating a database from sybase to sql server 2000. I Have already created objects in sql server 2000. I have to only populate it with the data. I have decided to genrate insert script from the aquadata tool and run the script againgt sql server database. It works fine except for few table which have 1,50,000 and 9,00,000 rows. It shows insufficent memory error when i try to run the script with 1,50,000 and the script with 9,00,000 doesn't open in management studio. Please help.


Bharath JrDBA

View 9 Replies View Related

Migration From SQL Server 2000 To 2005

Mar 2, 2007

I have a fairly large web application that was built with SQL Server 2000 and .NET 1.1. We're planning on moving to .NET 2.0 eventually, but there's a lot of work to be done before that happens. In the short term, we're looking to purchase a new database server and would like to upgrade to SQL Server 2005 at the same time. Is it as simple as recreating our databases on this new system and changing the connection string, or are there other gotchas? As far as what we're doing with SQL Server 2000, it's really nothing more than tables, views, and stored procedures. Thanks in advance for any advice.

View 4 Replies View Related

SQL Server 2000 To 2005 Migration

Feb 19, 2007

I am in a process of migration our current SQL Server 2000 (Standard Edition with SP3 running on 32 bit windows 2000 server) to SQL Server 2005 (Standard with SP1 running on X64 windows 2003 server)?

For migration does current SQL Server 2000 requires Service Pack 4 Installed?

View 1 Replies View Related

32-bit To 64 Bit Migration Of SQL Server 2005 (Deployment)

Jul 31, 2006

Hi

Do we need to perform any special checks when we deploy SQL Server application developed using 32 bit SQL 2005 Edition in 64 bit SQL 2005 Edition?

To my understanding, 64 bit SQL Server 2005 provides better memory management and provides high performance when compared to 32 bit and it should not be an issue in deploying the application developed in 32 bit SQL Server 2005 in 64 bit environment.

Any help/hints on deploying in 64 bit SQL Server (for a product[SPs, TSQL Stmts] developed using 32 bit SQL Server) is appreciated.

Thanks
Kart

View 1 Replies View Related

SQL Server Admin 2014 :: Separate Data Files / Log Files / TempDB / Backups

Jan 9, 2015

I proposed on a new server that we separate Data Files, Log Files, tempDB, Backups, etc. onto separate LUNS on a SAN with High Speed Solid State Drives.I was told that with the new technology with solid state SAN's that it would decrease performance and that it did not work the same way as it did when you had RAID 5's etc.I thought that if things were cared out correctly by a SAN Administrator they would know how to configure for optimal performance.

View 2 Replies View Related

Migration Of Several DB Files Spreaded Among Sever

Nov 6, 2007

al file groups into single file group and single file.

Hello, folks!

I have been reading this forum for several years (I think about 5 or so) constantly finding answers to all of my questions. So Thank You guys for all the time you spend here sharing your knowledge.

However, looks like it is time to ask for some help/advice.

Here is the situation.
We (company I work for/client of the company I work for) had a (sort of) web site which created very heavy load to the database (small web interface + heavy use of web services, "I want a blah quote" application. Dealing with performance and space allocation problems I've splitted data into several DB files (and did some other thing not important for my current problem). That helped somehow for some time. Eventually problem has been solved by migrating DB to MSSQL9 and by complete rebuild of existing web application. So old "not good" application/DB was left and no longer in active use, however client time to time goes to the old app (1-2 times per month) to extract some data for analysis.

Here is the problem.
1. I want to join all of that data into a single data file. (the thing I don't know how to do)
2. To free up hard drive by moving this database to external usb drive. I know! I know that it must NOT be done under any normal circumstances. However, this database is literally read only and there is mostly no use of it, so performance is no longer a subject of consideration. But it will help me to free up valuable space on hard drive array.

So, bottom line.
Would you be so kind to show me direction to dig in, which will help me to resolve problem #1?

Thank you!
Alex

View 3 Replies View Related

Migration From Sybase 8.0 To Mssql Server 2005

Apr 7, 2006

Hi all,

Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.

View 3 Replies View Related

Migration To Sql Express 2005 From Sql Server 2000

Apr 24, 2008

The Environment:
I have an old Windows 2000 BackOffice server (Retail but with no media) that hosts a small database (<50mb) that is hosted on the local SQL Server 2000 installation. The network has 8 PCs that connect to the database via ODBC connections. I just purchased a new server running Windows Server 2003 Standard Edition (OEM).

What I€™m Trying to Accomplish:
I want to decommission the old 2000 BackOffice server and move the database to the new 2003 Standard server. I€™m trying to do this on the cheap, so I really want to avoid spending thousands on a new SQL server license.

Things I€™m Considering:
1) Migrating the database from SQL 2000 Standard to SQL 2005 Express
2) Moving the database from SQL 2000 Standard to MS Access
3) Purchasing SQL Server 2005 licenses and upgrading
4) Purchasing SQL 2000 Server licenses


The options are pretty much listed in my order of preference. I€™d like to move from SQL 2000 Server to SQL 2005 Express, but I haven€™t really found a lot of material on the subject since people customarily go the other way.

Any advice or alternative recommendations would be much appreciated!

View 6 Replies View Related

SQL Server 2000 Migration To SQL Server 2005 Collation Change - Method?

Jan 24, 2008

Scenario
Recently moved a SQL2000 database to SQL2005.
Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS
Colaltion on SQL 2005 database server is Latin1_General_CI_AS

After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation.

What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' -
1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability>
on each varchar/char column

or

2) For each table
BCP out data
DROP TABLE
RECREATE TABLE (taking the new collation Latin1_General_CI_AS)
BCP in data

3) Other methods?

Thanks in advance
David.

View 4 Replies View Related

SQL Server Data Migration And Synchronization

Apr 13, 2007



Hi,



I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.



I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.



Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.



Note: Migration is from SQL Server 2000 to SQL Server 2005.



Thanks in advance.

Ritesh

View 9 Replies View Related

Is There A Way To Do A Bulk Migration Of DTS Structured Storage Files?

Sep 22, 2006

For a number of excellent reasons, I have exported the DTS packages that need to be migrated to SSIS to structured storage files. However, unlike the migration from a SQL Server source, the wizard doesn't allow a developer to select more than one package at a time.

Is there a way to do this in bulk that I am unaware of? I sure hope so as I have a couple of hundred to do and it's going to get very old very quickly if I have to do them one at a time!

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved