Mirroring and replication

Hi MSSQL friend,

We have a SQL2005 server which contains some replicated databases. We use merge replication and the publications are all local.

In order to make the server failsafe we need some kind of mirroring. Is this possible with replication?

Any ideas how to accomplish a failsafe scenario with replication?

Sincerely Edward

You can start by searching SQL Server Books Online, I searched for "replication mirroring" and found this:

Replication and Database Mirroring - http://msdn2.microsoft.com/en-us/library/ms151799.aspx

|||Thanks Greg!sql

Migration Of MSSQL instance along with security permissions

Hi All,

This is the scenario. Basically i work for a web hosting company now we have taken over control of a competitor and would like to migrate there existing data to our own MSSQL server's in order to integrate them into our automatic system etc etc ...

The current system is running MSSQL7.

The system been copied to is MSSQL2K.

Objectives:

Retain all security accounts listed on the MSSQL7 system and use them on the MSSQL2K system. This includes all the logins that use standard MSSQL login's. (Reason : To ensure that all the customers ASP pages work after the DB's have been copied.)
Backup all the databases on the MSSQL7 and restore them to the MSSQL2K system. Unfortunately system is running on a different network with firewall's etc in between. What type of maintenance plan and how should i implement the requirement to keep all the login account's?
Any help greatly appreciated......
thxone of the option can be like take all backups on either hdd or tape then connect it to ur server copy it from previous one to new one.
to copy all login info etc u can write a script if u need the script i can send u next time (this will take the info to a cursor and one by one it wil update.)
as far as sql 7 database schema and 2k schema is concerned i dont think it will be a problem.
this is an intersting case pl update me|||Hi ranjan apologies for not replying sooner (did not know if anyone had replied). I agree when u state that u dont think either that the difference between porting to 2000 is going to cause an issue. I have restored all the databases now but am in need of a little help / inspiration on how to port over the login names. Perhaps you can help or have a script that performs this task. Regards the script u have for updating i presume its independent to the current logins that are on the SQL2K system at present. How is this done?

Migration from sybase 8.0 to mssql server 2005

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.

Maybe these article will help:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx
http://www.microsoft.com/technet/itsolutions/migration/unix/sybsqlsv/default.mspx
http://www.microsoft.com/downloads/details.aspx?familyid=E7541305-891F-494A-B58B-2EED819C4411&displaylang=en
http://www.microsoft.com/sql/prodinfo/compare/sybase.mspx
http://www.devarticles.com/c/a/SQL-Server/Migrating-from-Sybase-to-SQL-Server/|||Basically that artical explaining migration from sybase|unix to sqlserver 2000 But not mssql server 2005 ,i gone through that article before but i did not find any help from that please can you make it clear.

Migration from DB2 to MSSQL Server 2000

Hi Friends,

I am doing my final semester project. It is a migration tool that converts the DB2 PL dialect into MSSQL Server's T-SQL dialect.
I am in need of sample DB2 PL files(procedures, UDFs, triggers) for testing the tool. Please point out me to some DB2 files repository links or if you have some files, please give me the same. I will use this only for testing purposes.

Appreciate your help.

Thanks & Regards,
JakeI suggest you place your request in DB2 threads too.|||Hi Protege,

Thanks for the suggestion. I have placed it in the DB2 thread also.

Thanks & Regards,
Jake

Originally posted by Protege
I suggest you place your request in DB2 threads too.

Migration from 7 to 2000

Hello,
How compatible is database Backup from MSSQL 7 to 2000?
Database has a lot of Procedures. Can there be syntax Problems?
Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
Regards,
Arto
Arto Ylikotila arto.ylikotila@.santamargarita.fiThere is always a possibility, but it is unlikely that you need to do any si
gnificant code changes, if at all.
One thing is datatype comparisons in WHERE clause, where SQL Server converte
d the constant side to the column
side. Today, SQL Server does the conversions according to the documented "da
tatype precedence" in Books
Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How compatible is database Backup from MSSQL 7 to 2000?
> Database has a lot of Procedures. Can there be syntax Problems?
> Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
> Regards,
> Arto
> --
> Arto Ylikotila arto.ylikotila@.santamargarita.fi
>|||Another issue I know is replacement of all SUSER_NAME calls with
SUSER_SNAME; if you use direct queries to syslogins and sysusers system
tables then you should replace joins made by id with joins made by sid (but
better use system procedures instead)
Database backup from MSSQL7 fully compatible with 2000... moreover you may
attach DB from MSSQL7 directly to MSSQL2000, and all the needed internal
changes will be made by MSSQL2000 itself. Note that you won't be able to
attach DB back onto MSSQL7 after using it as 2000's DB. Same thing with
2000's backups - they can't be restored with MSSQL7 engine
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u5QWmD0NEHA.680@.TK2MSFTNGP11.phx.gbl...
> There is always a possibility, but it is unlikely that you need to do any
significant code changes, if at all.
> One thing is datatype comparisons in WHERE clause, where SQL Server
converted the constant side to the column
> side. Today, SQL Server does the conversions according to the documented
"datatype precedence" in Books[vbcol=seagreen]
> Online.
> "Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
> news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...|||Hi,
SQL 7.0 Backups are fully compatible with SQL 2000.
For SQL 2000 (I assume that SP3a and post fixes are applied ) MS recommends
MDAC versions > 2.6x.
We had several problems with clients that has mdac versions < 2.6x (speciall
y sql servers with multiple instances and also have some localization probl
ems).
Regards..

Migration from 7 to 2000

Hello,
How compatible is database Backup from MSSQL 7 to 2000?
Database has a lot of Procedures. Can there be syntax Problems?
Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
Regards,
Arto
Arto Ylikotila arto.ylikotila@.santamargarita.fi
There is always a possibility, but it is unlikely that you need to do any significant code changes, if at all.
One thing is datatype comparisons in WHERE clause, where SQL Server converted the constant side to the column
side. Today, SQL Server does the conversions according to the documented "datatype precedence" in Books
Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How compatible is database Backup from MSSQL 7 to 2000?
> Database has a lot of Procedures. Can there be syntax Problems?
> Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
> Regards,
> Arto
> --
> Arto Ylikotila arto.ylikotila@.santamargarita.fi
>
|||Another issue I know is replacement of all SUSER_NAME calls with
SUSER_SNAME; if you use direct queries to syslogins and sysusers system
tables then you should replace joins made by id with joins made by sid (but
better use system procedures instead)
Database backup from MSSQL7 fully compatible with 2000... moreover you may
attach DB from MSSQL7 directly to MSSQL2000, and all the needed internal
changes will be made by MSSQL2000 itself. Note that you won't be able to
attach DB back onto MSSQL7 after using it as 2000's DB. Same thing with
2000's backups - they can't be restored with MSSQL7 engine
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u5QWmD0NEHA.680@.TK2MSFTNGP11.phx.gbl...
> There is always a possibility, but it is unlikely that you need to do any
significant code changes, if at all.
> One thing is datatype comparisons in WHERE clause, where SQL Server
converted the constant side to the column
> side. Today, SQL Server does the conversions according to the documented
"datatype precedence" in Books[vbcol=seagreen]
> Online.
> "Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
> news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...
|||Hi,
SQL 7.0 Backups are fully compatible with SQL 2000.
For SQL 2000 (I assume that SP3a and post fixes are applied ) MS recommends MDAC versions > 2.6x.
We had several problems with clients that has mdac versions < 2.6x (specially sql servers with multiple instances and also have some localization problems).
Regards..

Migration from 7 to 2000

Hello,
How compatible is database Backup from MSSQL 7 to 2000?
Database has a lot of Procedures. Can there be syntax Problems?
Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
Regards,
Arto
--
Arto Ylikotila arto.ylikotila@.santamargarita.fiThere is always a possibility, but it is unlikely that you need to do any significant code changes, if at all.
One thing is datatype comparisons in WHERE clause, where SQL Server converted the constant side to the column
side. Today, SQL Server does the conversions according to the documented "datatype precedence" in Books
Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How compatible is database Backup from MSSQL 7 to 2000?
> Database has a lot of Procedures. Can there be syntax Problems?
> Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)
> Regards,
> Arto
> --
> Arto Ylikotila arto.ylikotila@.santamargarita.fi
>|||Another issue I know is replacement of all SUSER_NAME calls with
SUSER_SNAME; if you use direct queries to syslogins and sysusers system
tables then you should replace joins made by id with joins made by sid (but
better use system procedures instead)
Database backup from MSSQL7 fully compatible with 2000... moreover you may
attach DB from MSSQL7 directly to MSSQL2000, and all the needed internal
changes will be made by MSSQL2000 itself. Note that you won't be able to
attach DB back onto MSSQL7 after using it as 2000's DB. Same thing with
2000's backups - they can't be restored with MSSQL7 engine
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u5QWmD0NEHA.680@.TK2MSFTNGP11.phx.gbl...
> There is always a possibility, but it is unlikely that you need to do any
significant code changes, if at all.
> One thing is datatype comparisons in WHERE clause, where SQL Server
converted the constant side to the column
> side. Today, SQL Server does the conversions according to the documented
"datatype precedence" in Books
> Online.
> "Arto Ylikotila" <arto.ylikotila@.santamargarita.fi> wrote in message
> news:%23GX1XB0NEHA.3380@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > How compatible is database Backup from MSSQL 7 to 2000?
> > Database has a lot of Procedures. Can there be syntax Problems?
> >
> > Should I change ODBC 3.70 to ODBC 2000 (Sql server versions)|||Hi
SQL 7.0 Backups are fully compatible with SQL 2000
For SQL 2000 (I assume that SP3a and post fixes are applied ) MS recommends MDAC versions > 2.6x
We had several problems with clients that has mdac versions < 2.6x (specially sql servers with multiple instances and also have some localization problems)
Regards.

Migrating to 64 bit.

I just finished installing MSSQL 2000 to an Itanium cluster and all went
well, but when I tried to use DTS to transfer the users, it says you can't
use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
transfer user accounts since I have several and don't know all the
passwords. I can move the databases, jobs, etc...
Nevermind, I just found this...
http://support.microsoft.com/kb/246133/
"Shawn" <shawn.camner@.ccci.org> wrote in message
news:OhRpg3Q3GHA.324@.TK2MSFTNGP05.phx.gbl...
>I just finished installing MSSQL 2000 to an Itanium cluster and all went
>well, but when I tried to use DTS to transfer the users, it says you can't
>use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
>transfer user accounts since I have several and don't know all the
>passwords. I can move the databases, jobs, etc...
>

Migrating to 64 bit.

I just finished installing MSSQL 2000 to an Itanium cluster and all went
well, but when I tried to use DTS to transfer the users, it says you can't
use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
transfer user accounts since I have several and don't know all the
passwords. I can move the databases, jobs, etc...Nevermind, I just found this...
http://support.microsoft.com/kb/246133/
"Shawn" <shawn.camner@.ccci.org> wrote in message
news:OhRpg3Q3GHA.324@.TK2MSFTNGP05.phx.gbl...
>I just finished installing MSSQL 2000 to an Itanium cluster and all went
>well, but when I tried to use DTS to transfer the users, it says you can't
>use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
>transfer user accounts since I have several and don't know all the
>passwords. I can move the databases, jobs, etc...
>

Migrating to 64 bit.

I just finished installing MSSQL 2000 to an Itanium cluster and all went
well, but when I tried to use DTS to transfer the users, it says you can't
use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
transfer user accounts since I have several and don't know all the
passwords. I can move the databases, jobs, etc...Nevermind, I just found this...
http://support.microsoft.com/kb/246133/
"Shawn" <shawn.camner@.ccci.org> wrote in message
news:OhRpg3Q3GHA.324@.TK2MSFTNGP05.phx.gbl...
>I just finished installing MSSQL 2000 to an Itanium cluster and all went
>well, but when I tried to use DTS to transfer the users, it says you can't
>use 32-bit DTS to transfer to 64-bit. Does anyone have a good trick to
>transfer user accounts since I have several and don't know all the
>passwords. I can move the databases, jobs, etc...
>