Migrating DTS packages Question: Dynamic Properties

Hi guys,

After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime, I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way?

' Add your code here

' Source Type = 2

' Global variable = glvTrade

' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value'

Regards

Hi,
I have same problem too.
' Source(Type = 2)
' Global variable = SPLastDate
' Destination = 'Tasks';'DTSTask_DTSExecuteSQLTask_7';'Properties';'SQLStatement'
How can i convert this code for ssis ?
Does anyone have any solution ?

Thans
Yasemin

Migrating DTS packages Question: Dynamic Properties

Hi guys,

After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime, I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way?

' Add your code here

' Source Type = 2

' Global variable = glvTrade

' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value'

Regards

Hi,
I have same problem too.
' Source(Type = 2)
' Global variable = SPLastDate
' Destination = 'Tasks';'DTSTask_DTSExecuteSQLTask_7';'Properties';'SQLStatement'
How can i convert this code for ssis ?
Does anyone have any solution ?

Thans
Yasemin

sql

MIgrating DTS packages of SQL 2000 to SQL 2005

Hello All,

I am working on a migration project of my database(lets name it DB1), from SQL 2000 to SQL 2005. I have some DTS packages in my SQL 2000 database which also needs to be migrated to SSIS. These DTS packages currently interacts with other database(lets name it DB2) which is also in SQL 2000 and which does the data transmission. The real issue is that the other database(DB2) also has some DTS packages which also communicates with DB1 (the db to be upgraded) and so when i migrate my DB1 to SQL 2005, i will have to change my DB2 packages also (although the change will be minor). Now considering that in future I might also migrate my DB2 to SQL 2005 I wanted to know what will be the right approach to follow. One is to modify the DTS packages of DB2 to accmodate the change in connection and the other is to migrate the DTS packages of DB2 also to SSIS.

Can anyone help me with this one.

Thanks in Advance

Mitesh

Hi Mitesh,

Something to consider: You can migrate a SQL Server 2000 database (DB1) to SQL Server 2005 and continue to run it at a SQL Server 2000 Compatibility Level. The implication is you may be able to continue connecting to DB1 from the DB2 DTS packages as you do now - it will just be on a different instance of SQL Server. I'm not sure what your DB2 DTS packages do exactly, so it's difficult to make that statement with more confidence.

There's also an Execute DTS 2000 Package Task available in SSIS. You can execute your existing DTS packages from SSIS. I've used this (and the aforementioned Compatibility Level) before as part of a migration plan from SQL Server 2000 to SQL Server 2005. It's nice because I don't have to get everything converted before starting to use the new database engine.

Regarding migrating between DTS and SSIS: that's a tough one. I teach ETL with SSIS for Solid Quality Learning. One of the things I share with students is the fact that SSIS is not the new version of DTS - it's a replacement. Microsoft did not start with DTS and modify it - they rewrote the entire application. This has some bearing on how easy it is to migrate from DTS. I've seen very simple DTS packages migrate easily, but that's about it.

There's so much new under the hood, you will most likely want to rebuild - and perhaps redesign - your packages in SSIS to take advantage of some of the stellar performance gains.

Hope this helps,

Andy

|||

Hey Andy,

Thanks for the reply will surely consider your suggestion. Just one more thing, when i use the Execute DTS 2000 Package task of SSIS i will have to change my connection as my database is migrated to SQL 2005 on another server. Correct me if i am wrong

|||

Hi Mitesh,

Yes sir - you will have to change your connection to target another database, server, or both.

Hope this helps,

Andy

Migrating data from DB2 to SQL Server

Hello,

I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.

Sincerely,

Eldhose Cyriaccontact1981 wrote:

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.

Yes, of course.
To you push data regularly or is this a once of.
If you have to do it often you could consider Websphere Information
Integegrator. It allows you to push/pull data through normal SQL from
and to DB2.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/on...iness/conf2006/|||Hi

There is migration information at
http://www.microsoft.com/sql/prodin...bm/default.mspx, migration
tools exist for Oracle, Access and Sybase but there does not seem to be a
released version for DB2
http://www.microsoft.com/sql/soluti...on/default.mspx I suggest you
contact the SQL Server Migration team at the email address under the related
links on that page.

John

"contact1981" <contact1981@.gmail.comwrote in message
news:1154637593.696660.274720@.p79g2000cwp.googlegr oups.com...

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.
>
>
Sincerely,
>
Eldhose Cyriac
>

Migrating Access XP database to SQL Server 2005 Express

I want to migrate my Access XP database to SQL Server 2005 Express Edition. The Start Menu does not display any migration assistant in SQL Server 2005 Express menu list.

How to migrate it?

hi,

never tried it my self, but have a look at http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

regards

|||

Access includes a tool called the upsizing wizard that will assist in moving your database to SQL.

Regards,

Mike

Migrating Access XP database to SQL Server 2005 Express

I want to migrate my Access XP database to SQL Server 2005 Express Edition. The Start Menu does not display any migration assistant in SQL Server 2005 Express menu list.

How to migrate it?

hi,

never tried it my self, but have a look at http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

regards

|||

Access includes a tool called the upsizing wizard that will assist in moving your database to SQL.

Regards,

Mike

Migrating Access to SQL Server

We use MS Access 2000 as our database, but run into lots of proplems. So we decided to research the migration to SQL Server.

I used Access Upsizing utitlity to migrate tables and their data to SQL server very easily, and all the relationships, indecies and other information are converted correctly.

Next is to migrate the queries. I found that to be a pain. Is there any tool out there that can do it for me? Any help is greatly appreciated.

Once that's done, then it's the application itself, but I am not worrying that for now.

Thanks, guysI don't have a tool to recommend.

Have you checked out the part of Microsoft's SQL Server 2000 Resource Kit that deal with migration?Chapter 5 - Migrating Access 2000 Databases to SQL Server 2000. There is a section called "Migrating Access Queries" you might find helpful.

Terri

Migrating a column from ntext to XML

After SQL Server 2005 migration, I'm trying to change my ntext column to XML type.

The "alter table TableName alter column XMLCol xml" command throw this error :

XML parsing: line 1, character 39, unable to switch the encoding

1. Do I have to reformat my nText column before the migration to XML type ?

2. Is there a way to create an XML data type with UFT-8 in SQL Server 2005 ?

Thank you for your help

Thank you for your help

the ntext column must contain well-formed xml to be converted. My guess is the the data in the ntext column looks something like:

<?xml version="1.0" encoding="utf-8"?><root/>

which specifies the wrong encoding for the the xml in an ntext column. If this is the case convert the column to varchar(max) first to fix the encoding, then to xml. For example:

alter table TableName alter column XMLCol varchar(max)
alter table TableName alter column XMLCol xml

If your ntest columns contain a mixture of

<?xml version="1.0" encoding="utf-8"?><root/>

and

<?xml version="1.0" encoding="utf-16"?><root/>

after alter the columns to varchar(max), update them to replace all the "utf-16" with "utf-8" before doing the alter to xml.

Dan AT pluralsight DOT com

|||

hi,

if you would be converting the column from ntext

and you have several hundereds of record in it already

it would be difficult to pinpoint the problem.

here's my suggestion

1. add a new column with XML data type. leave the old ntext column untouched

2. insert into the new column bby batch of 10, 20 or by hundred depending on the size of your table

3. what would be left are problematic not well formed xml

4. deal with the remaining data and insert to the new column

5. when everything is done. drop the old column

6. rename the new XML column with the previous column

regards,

joey

|||

Converting it to varchar(max) is still having the potential to lead to encoding issues or data corruption. Instead the column should be converted to varbinary(max) first and then to XML.

Best regards

Michael

Migrating a column from ntext to XML

After SQL Server 2005 migration, I'm trying to change my ntext column to XML type.

The "alter table TableName alter column XMLCol xml" command throw this error :

XML parsing: line 1, character 39, unable to switch the encoding

1. Do I have to reformat my nText column before the migration to XML type ?

2. Is there a way to create an XML data type with UFT-8 in SQL Server 2005 ?

Thank you for your help

Thank you for your help

the ntext column must contain well-formed xml to be converted. My guess is the the data in the ntext column looks something like:

<?xml version="1.0" encoding="utf-8"?><root/>

which specifies the wrong encoding for the the xml in an ntext column. If this is the case convert the column to varchar(max) first to fix the encoding, then to xml. For example:

alter table TableName alter column XMLCol varchar(max)
alter table TableName alter column XMLCol xml

If your ntest columns contain a mixture of

<?xml version="1.0" encoding="utf-8"?><root/>

and

<?xml version="1.0" encoding="utf-16"?><root/>

after alter the columns to varchar(max), update them to replace all the "utf-16" with "utf-8" before doing the alter to xml.

Dan AT pluralsight DOT com

|||

hi,

if you would be converting the column from ntext

and you have several hundereds of record in it already

it would be difficult to pinpoint the problem.

here's my suggestion

1. add a new column with XML data type. leave the old ntext column untouched

2. insert into the new column bby batch of 10, 20 or by hundred depending on the size of your table

3. what would be left are problematic not well formed xml

4. deal with the remaining data and insert to the new column

5. when everything is done. drop the old column

6. rename the new XML column with the previous column

regards,

joey

|||

Converting it to varchar(max) is still having the potential to lead to encoding issues or data corruption. Instead the column should be converted to varbinary(max) first and then to XML.

Best regards

Michael

Migrated Historical Snapshot

We have recently migrated (into a test environment) our RS2000 DB per the
microsoft migration instructions into RS2005.
When a history snapshot record is requested (Via ReportManager), we get an
internal RS Exception...
w3wp!library!1!11/13/2006-11:35:39:: i INFO: Call to
GetPermissions:<Roger!REPORTPATH>
w3wp!library!1!11/13/2006-11:35:39:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error compressing;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
w3wp!library!1!11/13/2006-11:35:40:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles flags=
ReferencedMemory, AllThreads, SendToWatson
w3wp!chunks!1!11/13/2006-11:35:40:: e ERROR: ###
SnapshotConverter(cb8c0d49-39e1-4775-ae6f-f73ac0fc68c4, True),
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at Microsoft.ReportingServices.Diagnostics.CompressUt il.checkErr(Int32 err)
at Microsoft.ReportingServices.Diagnostics.CompressUt il.UnCompress(Byte[]
input, Int32 outputBufferLength, Byte[]& output)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.UncompressNative(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.Uncompress(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.ReadAndUncompressBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.FillBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream..ctor(Stream
store, Int16 version)
at
Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.CreateReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, Boolean rawStreamRequested, ConnectionManager connectionManager,
String& mimeType)
at
Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.GetCompressedReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, ConnectionManager connectionManager, String& mimeType)
at
Microsoft.ReportingServices.Library.SnapshotConver ter.ConvertFromV1(ReportSnapshot snapshot, Boolean isSnapshotProcessing)
Has anyone sucessfully migrated history from RS2000 to RS2005?
- Roger
Could you post this in the reporting services newsgroup? I think it belongs
there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tx Whytboy" <TxWhytboy@.discussions.microsoft.com> wrote in message
news:18002B03-FAED-4825-A6E7-ED56B8668B77@.microsoft.com...
> We have recently migrated (into a test environment) our RS2000 DB per the
> microsoft migration instructions into RS2005.
> When a history snapshot record is requested (Via ReportManager), we get an
> internal RS Exception...
> w3wp!library!1!11/13/2006-11:35:39:: i INFO: Call to
> GetPermissions:<Roger!REPORTPATH>
> w3wp!library!1!11/13/2006-11:35:39:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., Error compressing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> w3wp!library!1!11/13/2006-11:35:40:: i INFO: Exception dumped to:
> C:\Program
> Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles flags=
> ReferencedMemory, AllThreads, SendToWatson
> w3wp!chunks!1!11/13/2006-11:35:40:: e ERROR: ###
> SnapshotConverter(cb8c0d49-39e1-4775-ae6f-f73ac0fc68c4, True),
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at Microsoft.ReportingServices.Diagnostics.CompressUt il.checkErr(Int32
> err)
> at
> Microsoft.ReportingServices.Diagnostics.CompressUt il.UnCompress(Byte[]
> input, Int32 outputBufferLength, Byte[]& output)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.UncompressNative(Byte[]
> compressedBuffer, Int32 uncompressedBufferLength, Byte[]&
> uncompressedBuffer)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.Uncompress(Byte[]
> compressedBuffer, Int32 uncompressedBufferLength, Byte[]&
> uncompressedBuffer)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.ReadAndUncompressBuffer()
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.FillBuffer()
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream..ctor(Stream
> store, Int16 version)
> at
> Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.CreateReadStream(Guid
> snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
> chunkType, Boolean rawStreamRequested, ConnectionManager
> connectionManager,
> String& mimeType)
> at
> Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.GetCompressedReadStream(Guid
> snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
> chunkType, ConnectionManager connectionManager, String& mimeType)
> at
> Microsoft.ReportingServices.Library.SnapshotConver ter.ConvertFromV1(ReportSnapshot
> snapshot, Boolean isSnapshotProcessing)
>
> Has anyone sucessfully migrated history from RS2000 to RS2005?
> - Roger
|||Yeah.. Missed it by one.. and I didnt realize that...
Sorry!
"Hilary Cotter" wrote:

> Could you post this in the reporting services newsgroup? I think it belongs
> there.
> --
> Hilary Cotter
sql

Migrate to new SQL Server

Hi
I'm currently setting up a new SQL Server 2000, and I'm in the process of
planning our migration. What is the best way to migrate databases and
logins?
Should I use the "Copy database wizard" for migration, or should I start by
enabling all logins manually on the new server, manually copy all dts
packages, and finally use "Copy Database Wizard" to only copy over the
database?
I have a small enviroment with only 8 small databases, and aprox 20 users
who typically all have access to the databases.
/A.Avoid the copy database wizard. To move the databases use
Backup/Restore, or Detach/Attach.
To move logins, see http://support.microsoft.com/?id=246133 "How to
transfer logins and passwords between instances of SQL Server".
When I have moved DTS packages I simply opened them on the source
server, then did a Save As and specified the other server.
Roy Harvey
Beacon Falls, CT
On Fri, 28 Sep 2007 11:40:21 +0200, "Andy.I" <Andy.I@.community.nospam>
wrote:
>Hi
>I'm currently setting up a new SQL Server 2000, and I'm in the process of
>planning our migration. What is the best way to migrate databases and
>logins?
>Should I use the "Copy database wizard" for migration, or should I start by
>enabling all logins manually on the new server, manually copy all dts
>packages, and finally use "Copy Database Wizard" to only copy over the
>database?
>I have a small enviroment with only 8 small databases, and aprox 20 users
>who typically all have access to the databases.
>/A.|||You may also use the following tool for tranferrng DTS packages..
http://www.sqldts.com/242.aspx
Thank you,
Saleem Hakani
WWW.SQLCOMMUNITY.COM
SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
SQL Server Radio, SQL Server Events..
"Roy Harvey (SQL Server MVP)" wrote:
> Avoid the copy database wizard. To move the databases use
> Backup/Restore, or Detach/Attach.
> To move logins, see http://support.microsoft.com/?id=246133 "How to
> transfer logins and passwords between instances of SQL Server".
> When I have moved DTS packages I simply opened them on the source
> server, then did a Save As and specified the other server.
> Roy Harvey
> Beacon Falls, CT
> On Fri, 28 Sep 2007 11:40:21 +0200, "Andy.I" <Andy.I@.community.nospam>
> wrote:
> >Hi
> >I'm currently setting up a new SQL Server 2000, and I'm in the process of
> >planning our migration. What is the best way to migrate databases and
> >logins?
> >Should I use the "Copy database wizard" for migration, or should I start by
> >enabling all logins manually on the new server, manually copy all dts
> >packages, and finally use "Copy Database Wizard" to only copy over the
> >database?
> >I have a small enviroment with only 8 small databases, and aprox 20 users
> >who typically all have access to the databases.
> >
> >/A.
>|||> To move logins, see http://support.microsoft.com/?id=246133 "How to
> transfer logins and passwords between instances of SQL Server".
> When I have moved DTS packages I simply opened them on the source
> server, then did a Save As and specified the other server.
> Roy Harvey
> Beacon Falls, CT
Are there any reason doing a dedicated move of the logins if I use Windows
Login on both the new and the old server? All logins are stored in A.D so
shouldn't it be sufficient to just add the apropriate A.D groups on the new
SQL Server and grant those the nececary rights on the databases?|||That would do the same thing. However, it would cause administrative
overhead.
That's why it's recommended moving logins using SSIS.
--
Ekrem Önsoy
"Andy.I" <Andy.I@.community.nospam> wrote in message
news:8883146D-F374-4C29-A347-C0214B0D5E6C@.microsoft.com...
>> To move logins, see http://support.microsoft.com/?id=246133 "How to
>> transfer logins and passwords between instances of SQL Server".
>> When I have moved DTS packages I simply opened them on the source
>> server, then did a Save As and specified the other server.
>> Roy Harvey
>> Beacon Falls, CT
> Are there any reason doing a dedicated move of the logins if I use Windows
> Login on both the new and the old server? All logins are stored in A.D so
> shouldn't it be sufficient to just add the apropriate A.D groups on the
> new SQL Server and grant those the nececary rights on the databases?
>

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?
Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
sql

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?

migrate to MS SQL2000 from Sybase

Could somebody point me to websites that would help in the migration to MSSQL 2000 from Sybase ASE 12.5? I also need replication documents also. We have 7 SQL servers that all replicate and we are thinking about moving to MS because of some benifits for out inhouse program.

thanks for all help..Check out the following article - it is based on sql server 7:

article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlsm/html/sybase2sql.asp)|||thanks..

migrate server to another machine

Hi,
I will migrate the databases using the Microsoft SQL Database Migration
Wizard to another machine.
Can(how) I keep the same all username and password and data?
Usually hwo to do that? Thanks.http://databasejournal.com/features/mssql/article.php/2228611
That should get you what you need.
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"js@.someone.com" wrote:
> Hi,
> I will migrate the databases using the Microsoft SQL Database Migration
> Wizard to another machine.
> Can(how) I keep the same all username and password and data?
> Usually hwo to do that? Thanks.
>
>|||Thanks for the help.
Can Microsoft SQL Database Migration Wizard used for
migration?
"MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
> http://databasejournal.com/features/mssql/article.php/2228611
> That should get you what you need.
> --
> MeanOldDBA
> derrickleggett@.hotmail.com
> http://weblogs.sqlteam.com/derrickl
> When life gives you a lemon, fire the DBA.
>
> "js@.someone.com" wrote:
>> Hi,
>> I will migrate the databases using the Microsoft SQL Database Migration
>> Wizard to another machine.
>> Can(how) I keep the same all username and password and data?
>> Usually hwo to do that? Thanks.
>>|||Hi,
The simplest way u can migrate ur database and logins are
restore the backup on the other server and trabfer all the logins from
dts package.
yes u can use microsoft migration wizard for migration.
from
Doller
js@.someone.com wrote:
> Thanks for the help.
> Can Microsoft SQL Database Migration Wizard used for
> migration?
>
> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
> > http://databasejournal.com/features/mssql/article.php/2228611
> >
> > That should get you what you need.
> > --
> > MeanOldDBA
> > derrickleggett@.hotmail.com
> > http://weblogs.sqlteam.com/derrickl
> >
> > When life gives you a lemon, fire the DBA.
> >
> >
> > "js@.someone.com" wrote:
> >
> >> Hi,
> >> I will migrate the databases using the Microsoft SQL Database Migration
> >> Wizard to another machine.
> >> Can(how) I keep the same all username and password and data?
> >>
> >> Usually hwo to do that? Thanks.
> >>
> >>
> >>|||>> yes u can use microsoft migration wizard for migration.
Thanks, using migration wizard will auto keep the logins?
"doller" <sufianarif@.gmail.com> wrote in message
news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
> Hi,
> The simplest way u can migrate ur database and logins are
> restore the backup on the other server and trabfer all the logins from
> dts package.
> yes u can use microsoft migration wizard for migration.
> from
> Doller
>
> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database
>> >> Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>|||Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my SQL
Server 2000 installation. Do you refer to the "Copy Database Wizard"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
> Thanks, using migration wizard will auto keep the logins?
>
> "doller" <sufianarif@.gmail.com> wrote in message
> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>|||I don't know other tools, but found "Copy Database Wizard".
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Can you tell use exactly what "database migration wizard" is found. I
> don't have such tool on my SQL Server 2000 installation. Do you refer to
> the "Copy Database Wizard"?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database
>> >> Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>>
>|||I'm confused. You referred to a tool named "Data Migration Wizard". Are you now saying that the tool
you meant is actually the "Copy Database Wizard"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"js" <js@.someone@.hotmail.com> wrote in message news:OlKQjWRyFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I don't know other tools, but found "Copy Database Wizard".
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my
>> SQL Server 2000 installation. Do you refer to the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>>
>>
>|||js wrote:
> I don't know other tools, but found "Copy Database Wizard".
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I
>> don't have such tool on my SQL Server 2000 installation. Do you refer to
>> the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message
>> news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> http://databasejournal.com/features/mssql/article.php/2228611
>> That should get you what you need.
>> --
>> MeanOldDBA
>> derrickleggett@.hotmail.com
>> http://weblogs.sqlteam.com/derrickl
>> When life gives you a lemon, fire the DBA.
>>
>> "js@.someone.com" wrote:
>>> Hi,
>>> I will migrate the databases using the Microsoft SQL Database
>>> Migration
>>> Wizard to another machine.
>>> Can(how) I keep the same all username and password and data?
>>>
>>> Usually hwo to do that? Thanks.
>>>
>>>
>>>
>
You can look up the description of the "Copy Database Wizard" in Books
On Line. It says that in addition to copying the actual databases, it
can also copy metadata like logins etc.
Regards
Steen|||> You can look up the description of the "Copy Database Wizard" in Books On Line. It says that in
> addition to copying the actual databases, it can also copy metadata like logins etc.
The reason I want to be certain what tool is referred to is that Copy Database Wizard does not carry
SID for SQL Server logins. So instead of letting CDW carry over logins, you use sp_help_revlogins
which will keep both password as well as SID for SQL server logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%2333kVZYyFHA.596@.TK2MSFTNGP12.phx.gbl...
> js wrote:
>> I don't know other tools, but found "Copy Database Wizard".
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my
>> SQL Server 2000 installation. Do you refer to the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>>> http://databasejournal.com/features/mssql/article.php/2228611
>>>
>>> That should get you what you need.
>>> --
>>> MeanOldDBA
>>> derrickleggett@.hotmail.com
>>> http://weblogs.sqlteam.com/derrickl
>>>
>>> When life gives you a lemon, fire the DBA.
>>>
>>>
>>> "js@.someone.com" wrote:
>>>
>>> Hi,
>>> I will migrate the databases using the Microsoft SQL Database Migration
>>> Wizard to another machine.
>>> Can(how) I keep the same all username and password and data?
>>>
>>> Usually hwo to do that? Thanks.
>>>
>>>
>>>
>>
> You can look up the description of the "Copy Database Wizard" in Books On Line. It says that in
> addition to copying the actual databases, it can also copy metadata like logins etc.
> Regards
> Steensql

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

migrate flat files into databases

From: lpatel5@.yahoo.com (Lina)
Newsgroups: microsoft.public.sqlserver.ce
Subject: Migration of Flat Files
Date: 26 Jun 2003 07:28:12 -0700
What is the best design approach for migrating about 1000 Flat files
from legacy applications to a single or multiple relational
database(s) on SQL Sever?
These files are not delimeted or in any fixed format.
Thank YouWhat you are asking for is almost magic. You have to have some structure in
each file or it cannot be imported into a relational database with a
row-column table structure. You may want to check with the legacy system to
see if it can export to a structured (delimited or fixed format) file. The
only exception is where each single file maps to a field in an individual
row in the database such as an image file mapping to an image datatype.
Then you will have to generate additional columns to capture file name and
date information if that is meaningful information.
If each file maps to an individual table, then you will need to generate the
table structure and then parse each file file into each table. BCP and/or
DTS are the tools to do that job. If multiple files can map to the same
table, you will likely have to add elements to the table to indicate which
file, since that information is probably meaningful to the system. In that
case, DTS is probably your best bet since it is more flexible.
Any way you look at this, it is not an easy task. Again, check and see if
there is an export utility for your legacy app that can get you to a format
that is easily imported.
Good Luck.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Amy Yuan [MS]" <amyy@.online.microsoft.com> wrote in message
news:00H8TwaRDHA.1060@.cpmsftngxa09.phx.gbl...
> From: lpatel5@.yahoo.com (Lina)
> Newsgroups: microsoft.public.sqlserver.ce
> Subject: Migration of Flat Files
> Date: 26 Jun 2003 07:28:12 -0700
> What is the best design approach for migrating about 1000 Flat files
> from legacy applications to a single or multiple relational
> database(s) on SQL Sever?
> These files are not delimeted or in any fixed format.
> Thank You
>