Terrence McGinnis
Reputation: 136
Is it possible to sync real-time 2 Database on 1 SQL Server?
I want to clone my Database1 to Database2 and sync it in real-time, just like mirroring but only using 1 SQL Server Instance
I tried Log Shipping and Mirroring but it's not possible to use only 1 SQL Server Instance
Upvotes: 0
Views: 63
Answers (0)
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- Check if table exists in SQL Server
- Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- DateTime2 vs DateTime in SQL Server
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?